On 11/10/99 9:53 PM, Rob Page at rob.page@digicool.com wrote:
IIRC from earlier investigations and presentations from Jim et al the cacheing data structure is keyed on the rendered string of SQL that is sent to the RDBMS. There are probably some zany dynamic SQL queries that could render the same query string for different input values. If the rendered string is different then the expected behavior is that the cache would miss causing Zope to reissue the query to the RDBMS.
Thers also aging... if you use <dtml-sqlgroup> a lot, you can easily do this. At some point we're thinking about tying this into statement handles as well... maybe really soon. Chris -- | Christopher Petrilli Python Powered Digital Creations, Inc. | petrilli@digicool.com http://www.digicool.com