Subject | RE: [firebird-support] Best firebird3 server mode for high usage and concurrency |
---|---|
Author | Rudi Feijó |
Post date | 2017-04-10T13:28:50Z |
>> Hello
>> Is SuperServer the best firebird3 if you have many large gdbs (about 100 of
>> gdbs averaging 2gb each) and very high concurrency?
>Define "very high concurrency".
>For the entire server? For specific databases?
Both, I guess. Each database is one of our clients, and each of those databases can have a range of 50 to 300 users at any given time, mostly querying and updating the same tables.
It’s a call center / dialing system. Most of the operation consists on the operator querying for a customer to place a call. Once found, the record is locked with that operator until the call ends.
So we have many users in a race condition on the same table.