On Thursday 26 February 2004 20:08, Da Jiao wrote:

Hi,

> Could anybody tell me what is
> the concurrent connection limitation for Firebird?

1024 is the hardcoded limit. In reallity it will handle between 1 and 1024
concurrent connections depending on how your application is written, the
hardware and OS the server is running on. (is that vague enough for you <g>).

We have a 'data collection', where clients are connected for a very short
time and only 'insert' a small amount of data, and that system averages about
750 concurrent connections.

We have a 'standard GUI call centre type application' that adverages about
200 concurrent connections.

We also have a 'batch processing statistically type app', and can only manage
about 5 concurrent connections due to the workload, but the hardware is
fairly 'light' as well.

Unless you are using real low-end hardware, the biggest thing that will
determine how many connections, and performance in general, is the what you
design, write and implement your application.

Phil

--
Discover a lost art - play Marbles
May 2004
ICQ: 760757 | AIM: pjshrimpton | Y!: pjshrimpton | pjshrimpton@...