challange in creating lobbies for online games with database decision
Recently, I am trying to create lobbies for online games.  There are more than 1000 online users playing the games . Therefore, I should make lobbies compatible with this huge amount of online.
At first, I had tried MySQL database to store lobby's data and fetching it every 5 seconds. This exploded my server, although public users had no access to it .

Then I came up with storing data on text files. It was also a disaster, because of complexity of the work.

another option I am looking forward is SQLite. 

Do you recommend this one , or you have better suggestion for creating lobbies of online games.

Project has been written with PHP.
challange in creating lobbies for online games with database decision
===

Recently, I am trying to create lobbies for online games.  There are more than 1000 online users playing the games . Therefore, I should make lobbies compatible with this huge amount of online.
At first, I had tried MySQL database to store lobby's data and fetching it every 5 seconds. This exploded my server, although public users had no access to it .

Then I came up with storing data on text files. It was also a disaster, because of complexity of the work.

another option I am looking forward is SQLite. 

Do you recommend this one , or you have better suggestion for creating lobbies of online games.

Project has been written with PHP.