Hi all, Just wondering if anyone has benchmarked CF's connection pooling. I'm getting results suggesting that turning on "maintain connections" does basically nothing for performance, and that using an alternative unpooled connection provider (in this case Spring's DriverManagerDataSource with jTDS) is way faster. The context to this is that Spring's doc says you shouldn't use their DriverManagerDataSource for production. Because it doesn't use pooling, it's not up to the job. So they say. However, testing on CF8.01 with 10 simultaneous requests, I'm getting about 50% better throughput with Spring's setup than going via CF's datasources. Now, benchmarking is a perilous undertaking, but this is my real-world app I'm using for testing, so the numbers are certainly meaningful for me. Seeing Spring's "do not use this - it is a toy" connection provider outperform CF, and not otherwise display any signs of being a toy, was a bit of a shock. Where I'm really going with this is trying to work out whether DriverManagerDataSource actually is a toy - I'm no mad performance tweaker, but a 50% hit is something I can't ignore - but I'll ask that on a Java list. Jaime
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318666 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
