Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re^2: which method is more faster?

by CountZero (Bishop)
on Jul 25, 2007 at 06:33 UTC ( [id://628637]=note: print w/replies, xml ) Need Help??


in reply to Re: which method is more faster?
in thread which method is more faster?

You are testing against a Sybase server (or using a Sybase-driver), whereas the original post is stating you are using MS SQL Server 2005, so at least your comments are confusing if not entirely misleading.

MS SQL Server 2005 being the latest incarnation of Microsoft's database server series, it seems unlikely that it does not support '?' placeholders.

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

Replies are listed 'Best First'.
Re^3: which method is more faster?
by bart (Canon) on Jul 25, 2007 at 10:33 UTC
    Agreed, try DBD::ODBC instead.

    There are still other methods, such as ADO, but in my experience, ODBC works well. (And I can't wrap my head around ADO, but YMMV.)

Re^3: which method is more faster?
by mpeppler (Vicar) on Jul 26, 2007 at 05:04 UTC
    Actually it's FreeTDS's implementation of Sybase's Client Library API that doesn't support placeholders (yet!).

    Michael

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://628637]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having an uproarious good time at the Monastery: (4)
As of 2024-04-25 16:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found