Re: How can I see where my script wasting time?

On 4/18/06, Jay Blanchard <jblanchard@pocket.com> wrote: > [snip] > I was developing one site with fake records in DB. Now, I put it live > whit > real records. The site is running ok, but it's painfully slow. Even for > grabbing an order from DB and showing it on screen, from 1-2 sec (while > developing) went to almost 10-15 sec?!? No, of records for orders is a > little bit over 200,000 - what is not "so much". > > I'm assuming that the problem is not in the script than in the way I > built > queries. > > My question is how can I check what's taking so long in execution of the > script/query? > Where to start with improving the script? > [/snip] > > Probably not the script. Do you have indexes on your tables? If you're using mysql, you can enable slow logs and that will help you: http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html -- Postgresql & php tutorials http://www.designmagick.com/