Subject Re: [ib-support] Re: Firebird v1 RC2 Installation Problem?
Author Georg Schäfer
Hi,

> I'm see the terms "users" and "connections" used interchangably here.
> Which
> one (limits) are we talking about.

User is the term used with licensing - connection is the technical view.
The licensed versions of IB allowed 4 connections per licensed user.

The technical limit of older versions of interbase was 256 (or 255?)
connections to the server, some of them used by the server itself. With one
connection per user you might reach the value of about 254 users (or some
less).
Newer versions of IB have set this limit up to 1024 (or 1023?). I've tested
IB 6 Open Source with someting more than 1000 connections and reached this
limit. I think firebird has the same limit.

Another problem is that the API-Funktion that delivers the actual users
attached on a database doesn't work correct on huge connection numbers. The
usernames are returned in a limited buffer, and therefore you can't see all
of them when the number of users exceeds some certain limit depending on
the length of the names.

We often have more than 100 connections to one database, but we can only
see 83 of them ...

Regards
Georg