Hi all...
I never took a look at the DBI::ProxyServer code, but I tried to whip up
something similar to the round-robin format that Tim suggests (to little
avail). Although my reasons were different than the original start of this
thread, there were two bits of functionality I was trying to get at:
1) ability to limit the size of the pool - to maintain, say, a 5
user license across 20 http processes.
2) prespawining of the limited pool during httpd startup - similar
to Apache::DBI's connect_on_init()
Anyway, if someone is formally taking on this task, just thought I'd voice
some functionality that would be interesting, and that others might be
seeking as well...
--Geoff
a willing tester :)
> -----Original Message-----
> From: Tim Bunce [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, November 29, 1999 5:04 PM
> To: Randal L. Schwartz; [EMAIL PROTECTED]
> Cc: Ed Park; Oleg Bartunov; modperl; dbi-users
> Subject: Limitations of DBI::ProxyServer (was: pool of DB
> connections?)
>
[snip]
> I'd like to see a mode added to DBI::ProxyServer whereby a single
> server process serviced multiple clients in a round-robin manner.
> Obviously in this mode there's a risk of slow queries cloging up
> (blocking) the proxy, but for many applications it would still be
> very useful. Most significantly it would enable connect_cached to
> be used to implement a (kind-of) connection pool.
>
> Sadly I don't have the time to work on that. I'm not sure if Jochen
> Wiedmann (the author of DBI::ProxyServer, DBD::Proxy and the RPC::*
> modules they sit on) either has the time or is interested in doing the
> work. On the other hand, given how useful this functionality would be,
> I'm sure there must be someone out there willing to have a go at
> implementing it. It can't be that hard. [Volunteers welcome but please
> coordinate with Jochen and myself.]
>
[snip]
> I hope that helps.
>
> Tim.
