Were the queries exactly the same? Did you incorporate something to ensure
SQL was not caching the results after each query?
------------------------------------------
Dan O'Keefe
TriPoint Technologies
[EMAIL PROTECTED]
954.501.3113
-> -----Original Message-----
-> From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
-> Sent: Thursday, August 03, 2000 12:33 PM
-> To: [EMAIL PROTECTED]
-> Subject: RE: oledb and native drivers
->
->
-> 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.
------------------------------------------------------------------------------
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.
