> Remember ADO needs no ODBC bridge (like JDBC). DB hits to MS > SQL are going to naturally be faster.
The DataDirect MS SQL driver used by CF is a type 4 JDBC driver. It doesn't use ODBC. I suspect that the ADO driver may well be faster, but I don't know if it's enough faster to make a significant difference. Microsoft's own benchmarking article on TheServerSide.com is a little fuzzy on that: http://www.theserverside.net/tt/articles/showarticle.tss?id=NET2BMNovember On the other hand, JDBC appears to work better against Oracle than ADO does - I'm shocked, shocked I tell you! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254807 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
