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

[Andy McKay]

Yup sounds like its too much data, one thing that can vary of course is
rendering on the browser, large pages can take a long time just to be
rendered, for example lots of tables on Netscape. Your example includes no
HTML so thats just an off the wall comment.
--
  Andy McKay.


----- Original Message -----
From: "Mayers, Philip J" <p.mayers@ic.ac.uk>
To: "'Capesius, Alan'" <CapesiusA@Sysmex.com>; <zope@zope.org>
Sent: Wednesday, March 21, 2001 6:16 AM
Subject: How slow should dtml-var be? (was: RE: [Zope] Problems with *BIG*
SQL queries)


> As mentioned, I'm doing really big SQL queries which return a HTML report
> that's about 1Mb. The ZopeTime trick suggested by Alan helps a lot - the
> time spent really is on the Zope side, and happens even with the most
> minimal file - just a:
>
> <dtml-var "ZopeTime()">
> <dtml-in QUERY>
> <dtml-var column1>,<dtml-var column2>,<dtml-var column3>,<dtml-var
column4>
> </dtml-in>
> <dtml-var "ZopeTime()">
>
> This takes about 4 minutes *on the server* - file return is quick. *Sigh*.
> This however:
>
> <dtml-var "ZopeTime()">
> <dtml-in QUERY>
> </dtml-in>
> <dtml-var "ZopeTime()">
>
> Takes about 30 seconds (which is reasonable):
>
> HTTP/1.1 200 OK
> Date: Wed, 21 Mar 2001 14:02:07 GMT
> Server: Apache/1.3.14 (Unix)  (Red-Hat/Linux)
> X-Powered-By: Zope (www.zope.org), Python (www.python.org)
> Vary: Authorization
> Connection: close
> Content-Type: text/plain
>
> 2001/03/21 14:02:07.2783 GMT
> 2001/03/21 14:02:46.6733 GMT
>
> I can only assume it's the namespace lookup in <dtml-var variable> - in
> fact, my calculations (9575 rows, 4 <dtml-var>s per row) make that 6ms per
> dtml-var, which isn't unreasonable. I guess I really do just have too much
> data...
>
> Using a PythonScript:
>
> print context.ZopeTime()
> for result in container.QUERY():
>     print "%s,%s,%s,%s" % (r.column1,r.column2,r.column3,r.column4)
> print context.ZopeTime()
> return printed
>
> ...doesn't seem to help
>
> Regards,
> Phil
>
> +----------------------------------+
> | Phil Mayers, Network Support     |
> | Centre for Computing Services    |
> | Imperial College                 |
> +----------------------------------+
>
> _______________________________________________
> 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 )
>