Yep! This is how I understand it as well and hence the initial
architecture of each thread having its own connection.
I am in the process of changing my application to use FAR less
connections and the test will be on Saturday evening when we expect
about 15000 to 25000 records in 1 to 2 hours. I will post the results
of my venture here shoudl anyone be keen.

--- In firebird-support@yahoogroups.com, Jonathan Neve
<jonathan@m...> wrote:

> loupisp wrote:
>
> >Hi Steffen
> >
> >Thank you for your response, much appreciated.
> >
> >Hmmmm. It sounds like this is where my problem lies. I have too

many

> >concurrent connections. The connections are normally not too

busy,

> >averaging about 30 to 90 txns per minute. The txns are very short
> >and are generally one Stored Procedure call that launches 2

triggers,

> >all in all probably about 4 SQL statements per txn. My problem
> >happens when the txns start going into 300-500 txns per minute,

the

> >database CPU utilisation goes to 100% and causes a MASSIVE

bottleneck.

> >
> >I use the Interbase components in Delphi 7, do you know if one
> >TIBDatabase connection can be used by multiple threads or do I

have

> >to create a connection-pool that they will utilise?
> >
> >
> The latter. You can't share database connection components across
> thread. As I understand it (but I might be wrong), it's the client
> library itself that's not thread-safe, or rather, that requires

that you

> use one connection and one TR per thread in order to be thread-safe.
>
> >--- In firebird-support@yahoogroups.com, "Steffen Heil"

<lists@s...>

> >wrote:
> >
> >
> >>Hi
> >>
> >>
> >>
> >>>Does anyone know what the suggested maximum number of concurrent
> >>>
> >>>
> >>connections a Firebird server can handle? Has anyone

successfully

> >>
> >>
> >managed a
> >
> >
> >>Firebird database server running 3 databases and 200 concurrent
> >>
> >>
> >connections?
> >
> >
> >>Apart of the maximum number of Sockets, your tcp/ip-stack can
> >>
> >>
> >handle, the
> >
> >
> >>limits for concurrent firebird connections are only dependent on
> >>
> >>
> >the average
> >
> >
> >>activity on these connections. Running only a brief query every

30

> >>
> >>
> >minutes,
> >
> >
> >>firebird should handle hundrets of connections with no problems.
> >>
> >>So what are your clients doing? Doing too much, 2 connections

might

> >>
> >>
> >already
> >
> >
> >>too much.
> >>
> >>Only one thing to remember: MGA was not designed to have long-
> >>
> >>
> >running
> >
> >
> >>transactions. Try to hard commit as often as possible.
> >>
> >>Regards,
> >> Steffen
> >>
> >>
> >
> >
> >
> >
> >
> >Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
> [Non-text portions of this message have been removed]