17 Mar
2003
17 Mar
'03
6:28 p.m.
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