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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
