Just to throw this out.. Most any benchmarking people do is not
really 'clean'.
I am not discrediting your benchmarking methodology but.
However in order to really clear my concious and say one is faster..
..I would want to seperate machines totally fresh installs of NT
CF, and SQL.
..The same data set used on each data souce.
..and a whole lot of things you do standard benchmakring
And OLE DB is reported to be somewhat faster, as I have read
in the CFDJ the author put up no hard numbers but more or less
stated that OLE DB was faster. I still am not sure, and would
like to see some rigirous becnhmarks to settle this.. So
If you could explain exactly how you obtained the benchmarks
I would love to hear it :)
There are four types of lies (In order from best to worst :) <G>
Lies, Damn Lies, Statistics, Benchmarks
Jeremy Allen
[EMAIL PROTECTED]
[Insert cool title here]
-----Original Message-----
From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 10:55 AM
To: [EMAIL PROTECTED]
Subject: RE: oledb and native drivers
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/[email protected]/
>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/[email protected]/
>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/[email protected]/
>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/[email protected]/
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/[email protected]/
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.
