title: Updating Database every X seconds
body: <p>First off, I'm building the application in Android, and using PHP as my web-services and database communication, I'm using MySQL database.</p>
  
  <p>Alright, here's the question:
  I'm building a Near Real-Time application and I need to update a row in my Database every 5 seconds, diffrent row for each user in the same table.. What is the best way to optimize the costs?
  I mean, It's working fine for 10 users.. but my guess is when I'll get 50-100 the DB will crash.
  And another important issue is the bandwidth, I really want to use as less as I can.</p>
  
  <p>Any advice? If I'll put all the requests into a queue intead of updating the specific row, will it prevent it from crashing? I mean.. there still will be 50 connections to the DB in the same time..</p>