Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

RE: Re: MS SQL Server

by Jouke (Curate)
on Aug 29, 2000 at 12:20 UTC ( #30085=note: print w/replies, xml ) Need Help??


in reply to Re: MS SQL Server
in thread MS SQL Server

I think there IS a real performance problem when you use ODBC instead of a native driver. ODBC is slow. I've never seen a fast ODBC connection.
Unfortunately I've never seen a native SQL Server driver for DBI. I once had to write some Perl to SQL Server, and we used ADO.pm (I believe Matt Sergeant wrote that one). It worked very well (and faster than DBI::ODBC), but that wasn't what you would want, since it wasn't a DBD-driver.
There IS a DBI::ADO driver available though, but I've never used it. It's at least faster than ODBC.

Jouke

Replies are listed 'Best First'.
RE: RE: Re: MS SQL Server
by JanneVee (Friar) on Aug 30, 2000 at 17:55 UTC
    I always have considered ODBC as a low level API to databases. The slowness that I experienced was by the "blocking" API calls. i.e. poorly written code....

    By using ADO you get some performance enhancements, even if the ADO connection goes through OLE DB and that goes through ODBC.

    One performance enhancement I can think of is Persistant connections. That is a thing you've wont get with a native MSSQL driver!

    Janne

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (3)
As of 2022-01-19 05:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:












    Results (55 votes). Check out past polls.

    Notices?