I am playing around with php on server and html/js client for a game/experiment. Right now, real time data is being updated and queried from mysql but in the very near future I want to expand from a few objects to more (depending on load). The query approach will not be sufficient to handle this. So a server side solution which keeps track of game data in memory is what I want but don't know what is appropriate to this situation.
Running Apache btw. Also, for the record, the long term goal is multiuser setup. I am willing to learn nodejs if that will help. I am also not sure when this gets up how to connect to the solution from php. I imagine long polling solution should be used.