I have to agree with Jochem there, I have run my own tests on occasion and have yet to see any substantial benefit one way or another.
--- Ben -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 10, 2002 3:22 PM To: CF-Talk Subject: Re: ODBC vs. OLEDB Scott Van Vliet wrote: > I have always heard that connecting to a SQL Server database is faster > through OLEDB, rather than using an ODBC DSN. However, after testing > my app against the two methods, I found that the page processing time > was almost identical (with ODBC even being faster at times!). Page processing time is a bad way to measure this. Try cfquery.executiontime to get better statistics. As to the validity of the statement that oledb is faster as odbc: I don't know. Jochem ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists