CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> Tips & Solutions

 Codecharge and Caching

Print topic Send  topic

Author Message
Benjamin Krajmalnik
Posted: 08/01/2008, 3:10 PM

We have an application which calls some very complex queries against a
multi-gigabyte database.
As more users were accessing the application, we got a huge performance hit
that made it unusable.
This meant refactoring some of what we are doing in the app (for example,
moving some of the calculation which are used by the pages to background
processes which store them in tables) as well as implementing CodeCharge's
built-in caching mechanisms.
As we started caching the pages, we encountered a major issue - some of the
insertions into the cache table failed due to the sql quoting of the page
context (lot's of javascript and ajax callbacks).
After scratching our heads trying to modify the actual page content to
prevnt this, we came with a better and bulletproof solution.
On inserting the page into the cache, we are base64 encoding the content.
Upon reading the cache, we are base64 decoding it.
This totally bypasses any and all issues in the insertion of the data into
the SQL database.

So, if any of you are experiencing issues with the caching, this will fix it
for you.

wkempees


Posts: 1679
Posted: 08/03/2008, 6:48 AM

B,
Thanks.

Long time I know.

Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.