Server getting slow on ajax calls

Question

Hi, In my webpage, I need to display the some information which will be updating frequently. For that I am using ajax calls, and showing it in the page using innerHTML. Im making the ajax request on each 3 seconds.. And in the php page (ajax request handler), Im opening the mysql connection using mysql_connect and at the end of the script Im closing the connection using mysql_close. But the server is getting slow because of the repeated calls. Is there any alternate solution ? Or how can I improve the performance of this ?

Answer 1

You should consider Micro Optimization

Also you may want to keep your connection persistent using mysql_pconnect
No hard and fast need to close your connection each time; it is closed upon end of script.

Your server is mainly getting slow because of calls after every 3 seconds. Try to find an alternative to that if you can.

Answer 2

• Make the query every 6 seconds?
• Make sure you're only returning -changed- data, and apply a diff instead of returning the whole set
• Cache as best as you can, rather than hitting the DB every time, if possible. For instance, if the data updates frequently, but is the same for everyone, you could have it only query every 5 seconds, and have the update read the cached values (write data to disk, or whatever works in your setup)