使用ajax每秒访问数据库

Question

I have a JavaScript script, that uses Ajax to call PHP page, the php page fetch the new updates from MYSQL database..

Ajax request is repeated every one second .

Does it a good practice to access database every second ? Is there any other suggestion to improve this operation ?

edit

I want to make something like twitter real-time updates, each second I will retrieve only the new data, if there is no new data, nothing will return from database ( but still access the database every 1 sec)

Answer 1

Make sure that you are not using setInterval but are using callbacks when your ajax call is successful or else you might have a backlog of calls that get stuck.

Also you might want to utilize some long-polling methods like websockets, comet, or server-sent-events.