[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
