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

This is the DTML that I used: <!--#var standard_html_header--> <h2><!--#var title_or_id--></h2> <p> This is the <!--#var id--> Document. <br> <HR> <!--#var Content--> <HR> <table> <!--#in DB_info--> <tr> <!--#in sequence-item--> <td><!--#var sequence-item--></td> <!--#/in--> </tr> <!--#/in--> </table> <hr> </p> <!--#var standard_html_footer--> The table has 65 rows, and is quite narrow (8 fields, no large text fields). I am using Zope-2.0.0a3, MySQL 3.21.33c and the latest python MySQL module. erik myllymaki erikm@islandnet.com