The more users, the slower it would get because some process will be waiting for a connection to be free. The solution to this problem is simple (but somewhat expensive), add more licenses. No code change is required.

>The middle tier pooling the connection for all the users is automatic, right? How about if the number of users keep increasing? How would that affect the performance in terms of using just one connection?