Interesting that I have someone who donated some code not long ago to handle
this. In v4 I planned on making this a standard feature of IBO. Is all you
would do is set a property, pool connection handles to true.

I'd like to see the code myself. Feel free to just implement right into
IBO's code and send me the modified files to consider for inclusion. I take
the best of each of your ideas and put my own little twist on it if
necessary and make it happen.

Trustware in action...

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <paulhope@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, February 27, 2001 5:44 AM
Subject: [IBO] Web DB Pool


> We dont have much experience in development of web/IB systems but are
> trying to 'position' ourselves for some upcoming customer
> requirements.
>
> One of the things that concerns me (using ISAPI) is that each DB
> access creates its own connection for each transaction. This causes
> a time delay and presumably can cause chaos when too many connections
> are attempted at once (also using IB5.6 has licence implications?).
>
> I therefore read with interest an article in The Delphi Magazine by
> Jason Southwell on Web Database Pooling.
>
> He presents components that can be used as follows
> When the dll is loaded a predefined number of connections are
> established
> When a query is requested it is placed in a queue and then attached
> to a free connection and processed. If the queue is full the user
> gets a 'Please try again' error.
>
> I have converted this to work with IBO - although needs some more
> work.
>
> So - questions to those more experienced in this stuff
>
> 1* Are the basic assumptions that this is built on correct and is
> it a good idea?
>
> 2* Does anyone want me to upload the code?
>
> Regards
> Paul
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>