[Zope] SQL Methods being called more than once

[Phil Harris]

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 )
>