>>Does this app sotre all active chats in the DB?

 

Yes.

 

>>I'm assumingou need the same sql server per chat room. 

 

That's not necessary. However you can split your users on multiple servers and SQL Servers.

 

To get good performance, it's better to set maximum users per room under 100. For example, if you have 5000 concurrent users, you can create about 50 rooms.

 

>>If you had multiple rooms you could split them up per sql servers? 

 

Yes, every room will have a URL. You can easily split the rooms into different sites:

 

For example: