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@[...].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 )