Nik wrote:

>
>
>
> I have an application that creates 50 threads, and then every 5
> seconds all the threads attach and insert some data into a firebird
> Super Server 1.5 database (this is currently using the firebird C++
> api rather than things like ibpp etc).

Ouch. In Firebird 1.5, connections are heavier-weight than they could
be. Could you leave the connections in place and just start & stop
transactions? Transactions are much lighter weight. Each connection
has a separate copy of that part of the metadata that it uses. If you
kept the connection you'd not only keep the metadata, you might also be
able to keep the prepared insert statement...

>
>
> Occasionally a thread will throw up;
>
> Unable to complete network request to host "127.0.0.1".
> -Failed to establish a connection.
> -Connection refused

One possibility is that your Linux is configured (as many are by
default) to limit the number of simultaneous connections.

Regards,


Ann