I have done side by side comparisons with ODBC and OLEDB using SQL 7.
Contrary to common belief, the OLEDB actually ran anywhere from 5-20 ms
slower than with ODBC. I just completed work on a new version of our ad
serving software and I obviously wanted the fastest option available. I
was very surprised to find that OLEBD just didn't cut it. Again, this is
with SQL 7, so results may vary with different db's.
The best option that I have found is ODBC and Stored Procedures. If you
want a serious performance boost in db intensive apps, definitely convert
as much code as possible to stored procedures.
IMHO,
Chris
----------------------------------------------
Original Message
From: "Robert Everland"<[EMAIL PROTECTED]>
Subject: RE: oledb and native drivers
Date: Thu, 3 Aug 2000 09:13:34 -0400
> In the testing I have found they have been just as fast as ODBC,
>plus add in the added headaches that certain commands your used to don't
>work in OLEDB, like the way dates are handled. It's really not a big deal
no
>article I have read has been able to give me hard numbers that prove OLEDB
>is faster so I will just stick with what works.
>
>
>Robert Everland III
>Web Developer
>Dixon Ticonderoga
>
>
>-----Original Message-----
>From: Rick Osborne [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, August 03, 2000 7:46 AM
>To: [EMAIL PROTECTED]
>Subject: RE: oledb and native drivers
>
>
>Native and OLEDB are *much* faster than ODBC. (For us it they were both
>literally an order of magnitude faster.)
>
>Someone may correct me on this, but as near as I can tell there really
isn't
>any difference between OLEDB and Native. That is, OLEDB is essentially
>"Native" for MS.
>
>If you are using SQLServer, I really can't think of a good reason why you
>wouldn't want to use OLEDB.
>
>-Rick
>
>-----Original Message-----
>From: Brian Mitter [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, August 03, 2000 6:21 AM
>To: [EMAIL PROTECTED]
>Subject: oledb and native drivers
>
>
>Hi All,
>
> Can someone explain the difference between oledb and native drivers for
>connecting to datasources?
>
>In the CF Administrator there seems to be native drivers for Sybase11,
>Oracle73, Oracle80, Informix83 and DB2. Should there be one for MS SQL? In
>the oledb section of the administrator there is sqloledb and microsoft jet.
>
>We are using CF Enterprise 4.01 and MS SQL 7.0 What is the best way to
>connect to the datasources on the SQL server? Any url's for more reading
>matter on oledb and native drivers? Ive tried the Allaire site but the
>search is still down.
>
>Thanks in advance
> Brian
>
>
>---------------------------------------------------------------------------
-
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>---------------------------------------------------------------------------
-
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
_____________________________________________
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
