----- Original Message -----
From: "Architect" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 2:02 PM
>
> 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
I would really liek to see the same tests against the SQLOLEDB datasource!
Adrian Cooper.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
