[Zope] Z-SQL Method performance

[Igor Leturia]

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=20
>.02 to .04 secs to=20
> > perform
> > ...
> > But telling a dtml-method to use the Z-SQL-Method in an=20
><dtml-in <name of=20
> > z-sql-method>> statement, it takes about 4-5 seconds, and=20
>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 -=20
> http://lists.zope.org/mailman/listinfo/zope-announce
> http://lists.zope.org/mailman/listinfo/zope-dev )
>