[Zope] SQL Methods being called more than once

Jatwood@bwanazulia.com Jatwood@bwanazulia.com
Thu, 2 Mar 2000 08:13:25 -0500


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