[Zope] MySQLDA performance

[Jim Fulton]

Erik Myllymaki wrote:
> 
> I have been doing some tests (admitedly incomplete and unscientific) with
> Zope and a MySQL database.
> 
> Using ZServer to parse a simple page with one "included" file = 18 hits per
> second(hps).
> Using PHP3 and Apache to parse a like page with the same "inlcuded" file =
> 16 hps
> 
> Using ZServer w/ a Z SQL method to display a table (select * from <!-- #var
> table-->) = 3 hps

:(

> Using PHP3 and Apache to display the same table = 13 hps.
> 
> Looking at the MySQL logs, they both keep a persistent connection.

Only one?  I'd expect Zope to create multiple connections if it was under load.

> Why is
> it so much slower with Zope?They are delivering the exact same content with
> each request. The parsers are doing the same job at the surface, although I
> don't have a full grasp of what goes on beneith...
> As a parser, they are similar in speed, but with the database connection,
> ZServer falters.
> 
> I tried starting ZServer with "-t 1" as I read in a previous post, but the
> result was similar.
> 
> Testing done using Pounder II.

How many rows are in the table?  What DTML did you use to display the
results? I notice that the mySQL extension module used in ZMySQLDA
doesn't release the Python global interpreter lock, which could
negatively impact performance.

Jim

--
Jim Fulton           mailto:jim@digicool.com   Python Powered!        
Technical Director   (888) 344-4332            http://www.python.org  
Digital Creations    http://www.digicool.com   http://www.zope.org    

Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email
address may not be added to any commercial mail list with out my
permission.  Violation of my privacy with advertising or SPAM will
result in a suit for a MINIMUM of $500 damages/incident, $1500 for
repeats.