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
