[Zope] ZSQL Cacheing

[Martijn Pieters]

At 03:53 11-11-99 , Rob Page wrote:
> > Do the queries  i.e.   sql.get_skin(username='default')
> > cache only for that given set of inputs? Or do they cache
> > regardless of the inputs? Because we have seen some evidence that the
> > result returned doesn't always change even when the username does and
>it _should_ have
> > to go look it up again.
>
>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.

Yup, caching is keyed on the arguments.


--
Martijn Pieters, Web Developer
| Antraciet http://www.antraciet.nl
| T: +31 35 7502100 F: +31 35 7502111
| mj@antraciet.nl http://www.antraciet.nl/~mj
| PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149
---------------------------------------------