[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