How slow should dtml-var be? (was: RE: [Zope] Problems with *BIG*SQL queries)

[Tony McDonald]

On 23/3/01 2:40 pm, "Matthew T. Kromer" <matt@digicool.com> wrote:

> Phil, one thing I'd recommend is consider using an external
> method to create your report; you might be pleasantly surprised.
> 
> This means, instead of
> 
>    <dtml-in QUERY>
>         <dtml-var ...> (etc)
>    </dtml-in>
> 
> You do a <dtml-var expr="myExMeth(REQUEST, QUERY)">
> 
> And your external method gets the REQUEST and QUERY objects to
> do its thing, format the results, and return it as one big item.
> 
> It might *significantly* cut down on your time, since what's
> killing you is <dtml-var> * 38300.
> 

This is very interesting. Do any DC gurus have anything to say on this?

I also agree that offloading things like summations onto your SQL database
is a *good thing*.

Tone.
-- 
Dr Tony McDonald,  Assistant Director, FMCC, http://www.fmcc.org.uk/
The Medical School, Newcastle University Tel: +44 191 243 6140
A Zope list for UK HE/FE  http://www.fmcc.org.uk/mailman/listinfo/zope