J, In the advanced tab on the edit page of a SQL Method there is a entry box for caching information. You could start by looking there. HTH Phil phil.harris@zope.co.uk ----- Original Message ----- From: <Jatwood@bwanazulia.com> To: <zope@zope.org> Sent: Thursday, March 02, 2000 1:13 PM Subject: [Zope] SQL Methods being called more than once
I have a page that has the same SQL Method called a few times....
<dtml-in sqlMethod query=start_query> Do some stuff </dtml-in>
<dtml-in sqlMethod query=start_query> Do some more stuff </dtml-in>
<dtml-in sqlMethod query=start_query> Do some more stuff </dtml-in>
Does anyone know the inner working well enough to tell me whether or not Zope actually makes two separate calls to the database or whether it makes one caches it and uses the results twice?
If you know and would like to expand on how Zope deals with caching SQL data that would be great I am trying to optimize my Zope installation and don't want to tax the database.
Thanks, JMA
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )