There is one other thing to consider in using connection pooling. I admit it is a bit off the beaten path but it bit me pretty good. I use Oracle stored procedures as much as I can. You cannot use connection pooling if your stored proc uses Global Temporary Tables. Since the connection is maintained, the table doesn't clear between calls. We turned on connection pooling in an effort to increase performance and quickly made a huge GTT (and correspondingly bad, voluminous data back to each user) which brought oracle and the web server down.
Warren Koch ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:318700 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
