Andy Ewings wrote: > I'm not sure I follow this response?
I was taking a wild stab because I had the same with your message :) > 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 It would save time. But would that be a significant amount of time? I don't think I would want to give up code portability to get some response time down 100 ms (reusing a connection takes little under 2 ms for my setup, so that is 100 ms for the 50 queries). 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
