[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