RE: Is there a performance advantage to using placeholders with Sybase?

Michael Peppler wrote:

>I haven't checked execute_array vs execute - off-hand I don't 
>think that there would be any real performance advantage. 

In some DBDs execute_array() is implemented to have just a few round trips to the database rather than one per row.  To get that with Sybase I imagine you must use bcp.

>For emulating placeholder behavior in more complex T-SQL code 
>- sure it could be done, but it would mean a lot more syntax 
>analysis in the prepare() code itself,

I think an explicit flag would be needed somehow because parsing other people's SQL is a pain.

Hmm, I did an experiment:

    my $sth = $dbh->prepare('my_stored_proc ?');
    $sth->execute('x');

No error was raised even though I connected with RaiseError and ShowErrorStatement.  I am using DBD::Sybase with freetds to connect to MSSQL.

-- 
Ed Avis <[email protected]> 

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________