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.
-----Original Message-----
From: Jacob Cameron [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 4:32 PM
To: [EMAIL PROTECTED]
Subject: FYI: Good CF optimization rules
[EMAIL PROTECTED] just sent this link into the
[EMAIL PROTECTED] list, and I thought that everyone on this list
could learn from it. Everyone who knows me knows that I scream about this
subject all the time, but here's an article from Allaire on CF thread
allocation. The Related links are also good.
Whoever asked last weekend about optimizing CF on NT should find
some good
info here.
http://www.allaire.com/Handlers/index.cfm?ID=8627
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
