I have developed an application using Ajax/PHP to automatically display MYSQL records. My worry is, I have set AJAX to always check mysql database every 10 seconds, from a bandwidth perspective, do I have any case to answer? If yes, what's the best solution.
this comet reference my lead you in the right direction http://en.wikipedia.org/wiki/Comet_%28programming%29
also here is another responce about AJAX and Chat implementation that should treat pretty the same behaviours