[Zope] Performance problem with zpscopgda

Roach, Mark R. mrroach@cimplify.net
17 Mar 2003 13:28:28 -0500


I am having a performance problem on my site that from what I can tell
(using CallProfiler) is related to a database query that returns about
600 rows. 

+0.2430   3.3720   74.8%  | | | +- buildSelect   
+0.2474   0.0434   1.0%   | | | | +- fetchSelectData   
+0.2534   0.0016   0.0%   | | | | | +- buildSelectQuery
          0.0375   0.8%   | | | | | |
          3.3676   74.7%  | | | | |

It is a very simple query, it only fetches two columns from a single
table. Is it normal for this to take over three seconds (less than one
second from php+pear)? I have enabled caching up to 650 records for 30
seconds, but this doesn't seem to make any difference.

Does anyone have any suggestions for how I can improve this?

Thanks,

Mark Roach