> 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 ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
