I'm not sure I follow this response? What I was saying/implying is that yes connection pooling would prevent you from having to reconnect "from scratch" each time but you would still be having to execute multiple SQL queries against the database which, if you got the DB to do it in one hit, would undoubtedly save you time
-----Original Message----- From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl] Sent: 04 November 2002 13:41 To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Andy Ewings wrote: > As far as connection pooling goes - I think there is a > misunderstanding as to what it does. The most lengthy process > (relatively) in going to a db and getting data is creating the > connection itself. Connection pooling just holds on to connections > for reuse - you still have to go back to the database and get the data > and bring it back to the client via that connection. What takes most time would be very database dependent. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
