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
|
|
|
|