[Zope] Z-SQL Method performance
Dieter Maurer
dieter@handshake.de
Wed, 3 Apr 2002 23:34:44 +0200
Rudi Wurm writes:
> my situation:
> ...
> My problem is the perfomance when executing a Z SQL Method
> ...
> my mysql-client tells me, that mysql by itself takes about .02 to .04 secs to
> perform
> ...
> But telling a dtml-method to use the Z-SQL-Method in an <dtml-in <name of
> z-sql-method>> statement, it takes about 4-5 seconds, and thats very long.
It's almost surely not the Z SQL Method but the DTML rendering that
makes it slow.
Use an External Method to generate the HTML from the query result.
Dieter