popmotsy Posted March 21, 2009 Share Posted March 21, 2009 hiii to all....i am facing with the problam of execution of select query,,,, i have page which contains atleast 15 to 20 select box,,valus comes dynamically from the tables....when i run this page on server,,,it takes toooooooooo much time,,,, then suggests me how can i speed up the execution time.... thaanks,,,,waiting for helpp ??? Quote Link to comment https://forums.phpfreaks.com/topic/150455-spped-up-execution-of-queries/ Share on other sites More sharing options...
PFMaBiSmAd Posted March 21, 2009 Share Posted March 21, 2009 Can't help you unless you post your code and your database table definitions. What your code and what your database design is now, determines what can be done to improve its' performance and without seeing what the code and queries are, no one can provide any specific answers that would apply to what you are doing. Quote Link to comment https://forums.phpfreaks.com/topic/150455-spped-up-execution-of-queries/#findComment-790280 Share on other sites More sharing options...
Mchl Posted March 21, 2009 Share Posted March 21, 2009 A must-read http://dev.mysql.com/doc/refman/5.0/en/query-speed.html Quote Link to comment https://forums.phpfreaks.com/topic/150455-spped-up-execution-of-queries/#findComment-790289 Share on other sites More sharing options...
fenway Posted March 27, 2009 Share Posted March 27, 2009 A must-read http://dev.mysql.com/doc/refman/5.0/en/query-speed.html That's a bit of a mouthful... there are plenty of "common sense" rules, too. Quote Link to comment https://forums.phpfreaks.com/topic/150455-spped-up-execution-of-queries/#findComment-795259 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.