[Zope] SQL Methods being called more than once

[Jerry Spicklemire]

It looks like you are indeed running the query multiple times. Unless you
are changing the data at some point internal to the process, which would
require your to "refresh" the results in order to have current data, you
could try:

<dtml-in sqlMethod query=start_query>
Do some stuff
Do some more stuff
Do even more stuff
</dtml-in>

Youd be "recycling" the result set, and sparing the DB backend.