[Zope] ZSQL Cacheing

[Christopher Petrilli]

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