Effective client connection management
Me and some of my colleagues are currently working on a large scale server project which is meant to handle a considerable amount of data from over 10000 users simultaneously.
Till recently we were using SQL (Postgres to be more specific) but apparently handing such an amount of mostly binary data with SQL isn't the most optimal solution. That's why we decided to switch to NoSQL and we found that Couchbase is a very good choice for that matter.
So here I am asking you on what is the most effective way to handle connections.
1) Have one connection for everyone?
2) Establish one connection for every user?
3) Have several connections in a pool and use the one that's not busy?
I would really appreciate your feedback.
Thanks in advance,