I've had that same problem many times, it was not the SQL query that was slow but the dtml rendering, and I've always been optimizing that rendering one way or the other. But I've never used an External Method (because I don't know what it is). Could someone explain a bit more of it? Thanks in advance, Igor Leturia
-----Jatorrizko mezua----- Nondik: Dieter Maurer [mailto:dieter@handshake.de] Bidalia: Asteazkena, 2002.eko apirilak 3 23:35 Nora: Rudi Wurm Cc: zope@zope.org Gaia: Re: [Zope] Z-SQL Method performance
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
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )