ZulfadlyAshBurn Posted June 28, 2011 Share Posted June 28, 2011 I am creating a interaction site for my cca and in on page there are too much lines of codes. It has too much Querying with MySQL Database and taking a long time too load. I have tried ajax but it still takes time to load too. Anyone have any idea to speed up the site? Quote Link to comment https://forums.phpfreaks.com/topic/240609-too-much-php-and-mysql-query/ Share on other sites More sharing options...
fugix Posted June 28, 2011 Share Posted June 28, 2011 can you post your code please Quote Link to comment https://forums.phpfreaks.com/topic/240609-too-much-php-and-mysql-query/#findComment-1235848 Share on other sites More sharing options...
Maq Posted June 28, 2011 Share Posted June 28, 2011 Quote Link to comment https://forums.phpfreaks.com/topic/240609-too-much-php-and-mysql-query/#findComment-1235890 Share on other sites More sharing options...
PFMaBiSmAd Posted June 28, 2011 Share Posted June 28, 2011 The problem is on lines 42, 43 and possibly 44 Also, AJAX would have limited affect on the problem because AJAX still makes a http request to the web server and if your server side code is not doing things efficiently, the AJAX must still wait to get the response from the server side code. What have you done to troubleshoot and isolate where the problem is actually occurring at in your application (keeping in mind that we don't have access to your code and your data on your server and so cannot duplicate the problem)? Quote Link to comment https://forums.phpfreaks.com/topic/240609-too-much-php-and-mysql-query/#findComment-1235897 Share on other sites More sharing options...
Maq Posted June 28, 2011 Share Posted June 28, 2011 To isolate the speed issue you can use profilers (XHProf & XDebug are popular) to find exactly where your code is slowing down. Quote Link to comment https://forums.phpfreaks.com/topic/240609-too-much-php-and-mysql-query/#findComment-1235899 Share on other sites More sharing options...
JonnoTheDev Posted June 28, 2011 Share Posted June 28, 2011 LOL Quote Link to comment https://forums.phpfreaks.com/topic/240609-too-much-php-and-mysql-query/#findComment-1235906 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.