http://www.perlmonks.org?node_id=531026


in reply to Re: DBD ProxyServer Not Caching Connections
in thread DBD ProxyServer Not Caching Connections

Thank you for that clarification.

What I'm trying to figure out (I'm learning as I go, but I'm running out of time) is whether or not the following scenario is correct (or even a good idea):

A cgi script on a bank of web boxes uses DBI->connect_cache to connect to a dbi proxy, which then uses DBI->connect_cache to a bank of db boxes.

I can't find anything seems to do this, or similar. Thanks for the pointer.

Harley J Pig
  • Comment on Re^2: DBD ProxyServer Not Caching Connections

Replies are listed 'Best First'.
Re^3: DBD ProxyServer Not Caching Connections
by perrin (Chancellor) on Mar 01, 2006 at 16:46 UTC
    What you're suggesting sounds reasonable, but I think it will require more work than you expect. The proxy server is still likely to be slow after this change, compared to direct access.

      Yeah, that's what we've decided. It would take more time to build our own proxy correctly and then optimize it than we have. So we've decided to stick with a simpler solution. Thanks.

      Harley J Pig