Not using connection pooling, in our environment, significantly slow down all process, and increases overhead to an order that eventually will bring a server to a complete non-responsive state. Basically, you end up tying up every available active thread request with long running DB requests, and the inactive thread pool 'overflows', to the point that active requests will complete, but inactive threads never transfer to active status.
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 Jaime Metcher wrote: > Hey Cutter, > >> in our environment we would be insane not to use connection pooling. > > ...unless it's actually faster to not use connection pooling. So is it? > > 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:318771 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4