Categories > Your tips & tricks >

A ReadCacheObject routine uses ezSQL's new disk cache

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: TomH
Date: 2006-05-02
Time: 04:25

A ReadCacheObject routine uses ezSQL's new disk cache

Now you can use an sql query that has been cached to disk - and save lots of dbserver thrashing.
JVincents ezSQL dbclass now has disk caching that saves db query results as an object that can automatically be read from ANY page that is making the same sql query!!! No sessions no cookies, no nothing else required.
AND the most wonderful Skrol29 has tha db plug-in that makes using the ezSQL class completely transparent in TBS.
You can see an example of how to make these two tools work together at http://tomhenry.us/tbs3/ click on ReadCacheObject link there -- please let me know if you finds some interesting uses for this, or want any help implementing it.