Up Prev Next
From: "Wechsler, Steven" <Steven dot Wechsler at mtvstaff dot com>
Subject: RE: Is there a performance advantage to using placeholders with Sybase?
Date: Jan 8 2008 2:41PM
Yes, I guess I should have stated that off the bat - I am using
FreeTDS...anyone know if it's been updated?
If not, although writing a stored proc beforehand isn't practical, what
I'm doing is simple enough that I could generate a stored proc on the
fly, use do() repeatedly and then drop it at the end. Presumably that
would be better than continual $dbh->do("insert table_x (select * from
table_y where ...)") - right?
Steve Wechsler | email@example.com
Sybase/SQL Server/MySQL Database Administrator
From: firstname.lastname@example.org [mailto:email@example.com]
On Behalf Of firstname.lastname@example.org
Sent: Tuesday, January 08, 2008 6:10 AM
Subject: RE: Is there a performance advantage to using placeholders with
OpenClient can do array binding, though I've never used it.
For execution of RPC (procs using placeholders) you must use the form
"exec procname ...".
And lastly - if you are using FreeTDS then most of this (placeholders,
array binding, RPC execution) doesn't work anyway, because FreeTDS's
implementation of OpenClient isn't complete in this respect (or at least
wasn't last time I looked - I have to admit that I don't really look all