I was just curious what is the max limit of providers/users on a single installation. I recall that Jason from the developer’s forum once mentioned he supported an installation with as many as 100 users. Is their a performance hit with that many users?
There is no arbitrary limit, and I would not expect any noticeable performance hit from having a relatively large number of users. By the way the users table also contains the address book entries.
On one of our hosting servers we hit what we initially thought to be a performance issue but is more of a programmatic issue when we hit about 12 hosted clinics on one server. Turns out that each database was using about 10 connections each. We just had to increase the amount of mysql database connections allowed and that seemed to have fix that issue. As to why is had about 10 connections each when only about 3 or 4 users we logged in is above my knowledge but if you have 100 users on one practice I am sure you would have to do the same.