Yes, I have indexes but can't say they are done perfectly though. :) -afan > [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? > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
