[Zope-DB] Zope-DCOracle2 vs Tomcat-JDBC performance

[Dieter Maurer]

Umberto Nicoletti wrote at 2003-5-23 15:53 +0200:
 > ... rendering large query results ...
 > Result is that with small pages in both size and number of records 
 > (under 5) displayed Zope is head to head with Tomcat.
 > 
 > With larger pages (about 50 records displayed with no whatsoever html
 > tables or other embellishment) Tomcat is MUCH faster (see below).

I expect this is DTML/ZPT overhead:

  Whenever you access any variable, Zope security machinery is
  consulted to check whether you are allowed to do this.
  Zope's security checks are very expensive.

Move your rendering into an External Method. There, you run
without the security checks.


Dieter