[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