> Is the pooling not smart enough to go looking for a > connection that already uses those credentials? If it is > smart enough, how would this be a bad thing? Unless you have > a really high traffic site? Not looking to be a wise ass > here, just expressing curiosity as this is bound to come up > here (at work) in the future. I've not really kept track of > how many sessions the system maintains across our various > applications.
Yes, it will reuse connections that have the same username and password. However, that's a lot less efficient if everyone has their own username and password than if there's a single username and password for all queries. There will be more connections, since each user will end up with his or her own connection pool, and there'll be less reuse for a given single connection. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303904 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4