A query table every second for notification. Is this a good practice?

Question

I have a project with notification features, and I figured out how to get a real-time notification. My idea is to query the table every second. I have a notification table, so whenever a client adds something, it will be inserted into the notification table, and then another client receives a notification requesting it. I am using ajax for this.

Is it good to query the table every second or bad programming practice? I use this only in localhost, and that is normal. Can such an idea negatively affect the site?

in advance for your answers.

Answer 1

Pinging DB - ; DB - HTML5/push-: http://html5hacks.com/blog/2013/04/21/push-notifications-to-the-browser-with-server-sent-events/

http://www.abrandao.com/2013/06/25/websockets-using-modern-html5-technology-for-true-server-push/

http://pusher.com/tutorials/html5_realtime_push_notifications

Answer 2

• ? -, , ? , , . (, JSON ) .
• . , 1 , , 10 ?
• , , , , . , Meteor , .