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.