RE: Re: 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

Comment on RE: Re: MS SQL Server

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	[reply]

Replies are listed 'Best First'.

RE: RE: Re: MS SQL Server
by JanneVee (Friar) on Aug 30, 2000 at 17:55 UTC

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

[reply]