How slow should dtml-var be? (was: RE: [Zope] Problems with *BIG* SQL queries)

[Jens Vagelpohl]

here's something that will probably help: push it into an external method.

mymethod.py (untested):

import string

def mymethod(self):
    log = []
    log.append(self.ZopeTime())

    for r in self.QUERY():
        log.append(%s,%s,%s,%s" % (r.column1,r.column2,r.column3,r.column4))

    log.append(self.ZopeTime())

    return string.join(log, '\n')

...and run it from the "test" tab after instantiating the external method
object. the time *should* improve considerably.

jens


> 
> Using a PythonScript:
> 
> print context.ZopeTime()
> for result in container.QUERY():
>   print "%s,%s,%s,%s" % (r.column1,r.column2,r.column3,r.column4)
> print context.ZopeTime()
> return printed
> 
> ...doesn't seem to help