I'm resusitating this three year old thread to ask the same question...
Does anyone have any experience with SQL Relay: http://sqlrelay.sourceforge.net/
It has matured significantly over the last few years.
---snip---
SQL Relay is a persistent database connection pooling, proxying and load
balancing system for Unix and Linux.
SQL Relay is ideal for:
speeding up database-driven web-based applications
enhancing the scalability of database-driven web-based applications
distributing access to replicated databases
throttling database access
accessing databases from unsupported platforms
migrating applications from one database to another
SQL Relay supports the following database backends:
Oracle MySQL mSQL PostgreSQL Sybase MS SQL Server
IBM DB2 Interbase Sybase SQLite ODBC MS Access
The SQL Relay client API's support advanced database operations such as
bind variables, multi-row fetches, client-side result set caching and
suspended transactions. SQL Relay has native client API's for the
following languages:
C C++ Perl Python PHP Ruby Java TCL Zope
SQL Relay provides drivers for the following database abstraction layers:
Perl DBD Python DB Ruby DBD PHP Pear DB
An application coded using another database's native client API may be able to
use SQL Relay without modification. SQL Relay provides drop-in replacement
libraries for:
MySQL PostgreSQL
SQL Relay also features:
command line clients
a GUI configuration tool
extensive documentation
---snip---
It does now support stored procedures for "most databases", though
there are some caveats. (One is that stored procedures for Sybase can't
return result sets, only 'out' variables. I asked the author, David Muse,
about it and he seemed to think it should be straightforward to support.)
Tim.
On Thu, Oct 23, 2003 at 10:43:07AM -0700, Henri Asseily wrote:
> On Thursday, October 23, 2003, at 10:09 AM, Tim Bunce wrote:
>
> >On Thu, Oct 23, 2003 at 06:50:21PM +1000, Ron Savage wrote:
> >>Hi Folks
> >>
> >>Anyone have experience with this:
> >>
> >>http://sqlrelay.sourceforge.net/
> >
> >Funny you should mention that. I've just had an email conversation
> >with the author (Dave Muse) to suggest that he place the relevant
> >modules on CPAN.
> >
> >I'd be very interested in reports of any experience, good or bad,
> >people may have had with SQL Relay. (Details of versions, or
> >approximate date, plus what database interface was used would be
> >handy.)
> >
> >Tim.
>
> Haven't tried it, but from the (extensive) docs, it only supports
> stored procedures for Oracle. That's a little at odds with its aim of
> improving speed for database querying. I can't use it in my environment
> for this reason.
>
> On a related note, it's amazing that people don't see stored procs as
> being one of the most effective ways to increase query speed, both on
> complex queries and simple ones when called very often.
>
> H.
>
