[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