> The better performance of Type 4 drivers is mainly when > compared to using a Type 1 driver. I can imagine Type 2 > being faster as Type 4 because you can implement certain > features, such as a connection pool, on a lower layer > so if you have both CF MX and BlueDragon running on one > system they can share a connection pool. But unless you > are moving massive amounts of data around, the difference > in processing speed of normal queries should be marginal. > If you have a query taking 100 ms, of which 80 ms in the > database and 20 ms in the JDBC layer, a 50% faster JDBC > layer will only result in a 10% faster query.
For most deployments I've seen, this wouldn't be an issue, since you wouldn't be running multiple app servers on a single machine. I'd be happy to shave 10 ms off of every query running on a production server, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
