Hello Group,

In response to this thread:
http://tech.groups.yahoo.com/group/firebird-support/message/84277

I have introduced a mutex into our TIBDatabase wrapper object to make
sure only one TIBDatabase object is performing the inherited
'DoConnect' call at a time within that process.

I have built a test application that creates 1000 threads each
attempting to connect at the same time to make sure that

1. No thread attempts DoConnect unless it holds the mutex.
2. The mutex does not cause an unreasonable bottleneck.

I am satisfied that both of these are true.

I then increased the time each thread holds the connection open to 20
seconds, but noticed something interesting. My laptop (XP SP2 / 1.5
Classic) would not create any more than 52 fb_inet_server processes.

Drilling a bit further into things, from the firebird log file, there
are lots of the following two messages:

LAPPY (Client) Mon Mar 05 10:07:05 2007
INET/inet_error: read errno = 10054

LAPPY (Client) Mon Mar 05 10:07:05 2007
INET/inet_error: receive in try_connect errno = 203

I know what 10054 means, what does the second error mean and is it
significant?

It is quite probably that hardware-wise, my laptop can not support
that many connections, so I am not overly concerned if the error is
'resource related' as our servers are significantly better resourced
than a laptop, but if it is something I should look deeper into, then
any help is appreciated.

TIA

Adam