> I'm getting "too many connections in use" when trying to connect
...
> Or is there some trick I can use inside my DLL to handle this?
depending on how the connections are used (lots of short requests, or
long running queries?) are you also talking about sessions? ie
connecting and disconnecting from a database? using the same/different
user/password?
if using lots of short queries, you can manage connection/session
pooling yourself. have a pool of 10/50/100 connections that get
acquired/released as appropriate, if none are available then maybe use
a queue to manage.. theres a few techniques available here.
if you are currently connecting/disconnecting with same user/pass then
you can see a _big_ speed improvement.
or you've already considered and found this not an appropriate
approach.. ah well, i tried :-)
cya..
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
