Subject FB 1.5.2 CS limited to 32 users?
Author Bradley Tate
Hi,

We're hitting performance limits with SuperServer and I'm having big
problems getting Classic running adequately on a multi-processor box.

Server: Dual Opteron
OS: Suse Linux 9.3, kernel 2.6.11 SMP
RAM: 2G
FB Version: FirebirdCS-1.5.2.4731-0.i686.rpm

We have a little program which runs on a Windows client (W2k) and
creates lots of processes which run queries against the server. For
some reason it won't create more than 32 processes agains a Classic
server, while with an SS server it creates hundreds.
I thought the problem might be in the semaphore settings, so I increased
SEMOPM in the linux kernel to 200, and LockSemCount in firebird.conf to
150. Rebooted everything and I'm still stuck at 32 processes. Then I
fiddled with ibconfig on the client, increasing the SEM_COUNT parameters
from 32 to 100. I don't know if they do anything but thought it was
worth a try. No luck.

Any help would be appreciated as I'm stumped. What I really need is
closer to 300 simultaneous connections so 32 is not a lot of use to me.
Hopefully I've done something stupid and easy to correct.

Thanks,
Bradley.