[Zope] MySQLDA performance

[Erik Myllymaki]

>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