I used one clean machine with fresh installs of NT, CF, and SQL 7.
I used the same db and set up 2 connections, one ODBC (AdServer) and one
OLEDB (AdServer_o). I then ran a single query on a static data set 20
times for each and averaged the execution time for each. This was repeated
10 + times (I say + because I didn't believe the results at first, so I
gave it a few more runs).
The data contained current campaign information from the existing ad server
that were dumped to the new db. The test was to select random campaign
banners for return to the client process.
Again, I was testing everything I could think of to get the best
performance possible. I'm also not a newbie with my first copy of sql/cf,
so I have a very solid understanding of how to contruct performance minded
queries.
I was satisfied enough with my results to stick with ODBC, and this ad
server is serving over 40 million impressions a month, so I wasn't
"benchmarking" just for the sake of it.
You of course are free to do whatever tests you like. The above served my
purpose, and maybe it will save others the time and effort.
Chris
----------------------------------------------
Original Message
From: "Jeremy Allen"<[EMAIL PROTECTED]>
Subject: RE: oledb and native drivers
Date: Thu, 3 Aug 2000 11:56:03 -0400
>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/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.
>
>---------------------------------------------------------------------------
---
>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.
