Reduce server load, real-time data
I am using Jquery, JSON, & ASP to pull realtime from a database every 3 seconds via setInterval. This is working great, however, I will soon have 50 users viewing the same website looking at their individual real-time statistics... so instead of 20 requests/minute (3 per second) I'm fearing that the number of requests would increase exponentially (50 users * 20 requests/minute = 1,000 requests/minute) if the intervals are determined by clients browser launch.
Does anyone know of a way that I could somehow limit the requests, all while displaying the real-time data?
Also, I was thinking about writing all 50 users data to text files every X seconds.. then have the Jquery call the file instead of query the DB, however, I think I'd run into a caching issue on the browsers this way. Modifying browsers settings is not an option.
I saw this plugin but wasn't sure if this is what I'd need:
Any Ideas?