Jim,
The debate rages on .... every time I look at this I seem to get a
different answer depending on version of everything running and the
specific situation. So to answer you it depends on your versions.
I ran some similar tests when SQL server 7 came out ..and found OLE DB
to marginally faster. Anyway, in order to really judge the performance
you need to run a variety of queries lots of times. 3 queries a
performance test does not make. Although its for SQL server, this
article has some interesting insight on how connections work and other
performance tips.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=16272
In your case regardless of the performance ... your running Access ...
use OLE DB
their can be stability problems with the ODBC MS Knowledge Base article
# Q222135
Regards,
-eric
------------------------------------------------
Common sense is genius dressed in its working clothes.
-- Ralph Waldo Emerson
Eric Barr
Zeff Design
(p) 212.714.6390
(f) 212.580.7181
-----Original Message-----
From: Architect [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 9:07 AM
To: CF-Talk
Subject: OLEDB vs. ODBC
I have set up an OLEDB datasource and an ODBC datasource within
the
Coldfusion Administrator (4.5.1 Sp2) so I can compare the processing
times
of each datasource. I then ran each datasource on the same database and
the
same .cfm file. The database is an Access 2000 database, my provider is
Microsoft.Jet.OLEDB.4.0, my system is W2K Sp1, and the browser is IE
5.5.
The OLEDB was actually slower than the ODBC connection. I have read
that
OLEDB was faster than ODBC. Is the test I've run the exception to the
rule?
Are there modifications to Coldfusion Administrator that will allow
OLEDB to
run faster?
Attempt 1 2 3
ODBC (milliseconds) 14100 14130 13710
OLEDB (milliseconds) 18827 18507 18337
Thanks,
Jim Christiano
Clearwire Technologies, Inc.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
