I guess it depends on your application, and the traffic you expect. One of our servers will process 500k db requests in a 4 hour period (according to FusionReactor), so in our environment we would be insane not to use connection pooling.
Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/learning-ext-js/book _____________________________ http://blog.cutterscrossing.com [email protected] (Jaime Metcher) wrote: > 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:318674 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
