06-23-2010, 06:39 PM
I wrote a PHP/AJAX chat for a website. Everything works great. However, the client that will be using this will potentially have thousands of people logged in at any given time. The chat currently checks for new posts every couple of seconds, but with so many users, this could easily overload the MySQL database the posts are stored in. I am trying to think of a way of overcoming this obstacle. How might I push this data? Do I need to think about using socket programming?