Im using PHP and ratchet, im dealing with how i can create an event from the serverside and push it to the clients. I know i can use ZeroMQ, but this will also create an overhead, each time an event has to be notify, a new socket connection is made.
So i was wondering, wouldnt it better to have thread which is always selecting from a mysql table named "SocketQueue" using memory as engine?
Does this architecture makes the app lose the atribute of "Realtime" ?