kairno Posted December 6, 2007 Share Posted December 6, 2007 Hi, i doubt the title is very explicit so here's what i want to do : i have an SQL database {MySQL to be precise} and i want to update a queue in a page without constantly query-ing the database, i'm using ajax now, but the traffic on the server is killing me... in short : a new user visits my site the event is transmitted to a perl script through an unix pipe the perl script inserts data in my database an ajax script checks the database every secont for new users and updates a queue line for some admins as far as i can see it, the best way to acheve the updated list is to have the ajax script check the database on a certain event..but i have no idea on how to do this... as you can see, executing a query every second for every logged admin is not the best solution.. but i don't know any other... Quote Link to comment https://forums.phpfreaks.com/topic/80482-queue-from-sql-update/ 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.