I couldn't agree with you more ! Stored procedures are always the way to go.
Chuck
[EMAIL PROTECTED] 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.
