GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Question for Programmers: What's a good way to see if a browser connection to a server is active?

NatalieMojoHost · 06-26-2019, 10:58 AM

Ajax is a good solution if there are no load issues.

One caveat I'd point out there is that UPDATE queries tend to be quite heavy on a database, especially if you're dealing with hundreds of users online at any time, or updating on a large table. If the information does not need to be persistent, I would update something like a memcached key or redis object for each user, as those are much less intensive than running updates in SQL. Redis could be configured to save the changes to disk every X writes/minutes for some amount of persistence as well (though not as reliably as SQL, and then that's another database service you need to maintain/backup/etc) - just something to consider.
If it is a busy site, I think it would be better to use websockets for this kind of thing, and Redis to persist data.

06-26-2019, 10:58 AM
NatalieMojoHost Confirmed User Industry Role: Join Date: Aug 2013 Posts: 1,474	Ajax is a good solution if there are no load issues. One caveat I'd point out there is that UPDATE queries tend to be quite heavy on a database, especially if you're dealing with hundreds of users online at any time, or updating on a large table. If the information does not need to be persistent, I would update something like a memcached key or redis object for each user, as those are much less intensive than running updates in SQL. Redis could be configured to save the changes to disk every X writes/minutes for some amount of persistence as well (though not as reliably as SQL, and then that's another database service you need to maintain/backup/etc) - just something to consider. If it is a busy site, I think it would be better to use websockets for this kind of thing, and Redis to persist data. __________________ MojoHost.COM \| natalie at mojohost dot com \| Skype natalie.ac \| Telegram @znatalie. Since 1999: 70 Adult Industry awards for Best Hosting Company and professional excellence.