I have a very extensive site that is being rewritten in Lasso 9. To try and improve load times because of the massive number of database calls per page, and the fact that all of the various sections of a page all load content based on a users access level, I create caches for each block of the page for each user access level.

So, each cache is setup like this:

the $page variable is setup as one of the first items on the page and the $access variable is a numeric session variable loaded after the user logs in.. So I have about 25 individual page variable options, probably 8-12 blocks per page, and 3 access levels which would give me somewhere around 600-700 caches (most of them pretty small).

[var(cache) = $page + '_block_1c_' + $access; cache(-name=$cache, -expires=86400)]

The problem that I=92m having is that when the client=92s web manager logs into the admin and adds a lot of new information, the caches all need to be wiped clean so they can reload–I used to use code that I got from this list to automatically get the global variables, find the ones that start with =91_cache=92 and remove them all.

The code I=92m using is from the following post:
http://www.lassotalk.com/Re-Deleting-all-caches-8-5-6.lasso?273108

This no longer works–does anyone have any ideas as to what I can do?

NOTE: I have tried to keep a database table of all of the possibilities and am temporarily having it go through the list and remove them, but I will always have to remember to add them to this table if I want them wiped.

Thanks!
Steve

Steven J. McIntosh
Director of Technology
Equitek, Inc. - Oak Park / Chicago
steve@equitek.com
708-386-8300

#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>