每秒查询一次表以进行通知.这是一个好习惯吗? [英] query table every second for notification. Is it a good practice?
问题描述
我有一个具有通知功能的项目,我想到了如何实时获取通知的想法.我的想法是每秒查询一次表.我有一个通知表,因此每当客户端添加一些东西时,它将插入到通知表中,然后另一个客户端通过查询来获得通知.我使用ajax来做到这一点.
I have a project that has notification functionality and I came up with an idea on how to get a notification real time. My idea is to query the table every second. I have a notification table, so whenever the client is adding something it will insert to the notification table and then the other client gets the notification by querying it. I use ajax to do this.
每秒查询一次表是好事还是不好的编程习惯?我只在本地主机中使用它,这很好.当网站上线时,这种想法会产生负面影响吗?
Is it good to query the table every second or it's bad programming practice? I only use this in localhost and it's fine. Do this kind of idea affect negatively when the site goes live?
预先感谢您的回答.
推荐答案
每秒对数据库执行一次ping操作不是理想的方法;您可以结合使用数据库触发器和HTML5 websockets/push通知: http://html5hacks.com/blog/2013/04/21/push-notifications-to-the-browser-with-server-sent-events/
Pinging the DB every second is not the ideal way to do this; you can implement a combination of DB triggers and HTML5 websockets/push notifications: 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
这篇关于每秒查询一次表以进行通知.这是一个好习惯吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!