I share the same assumptions, seems foolhardy to do it differently, both for performance and logistical reasons. Anyone from the CF team still around to comment? It's not even 4:30 yet. ;)
--- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Friday, July 11, 2003 4:19 PM > To: CF-Talk > Subject: RE: datasource connections > > > > Can anyone give me an official answer to this question > > (unspecified is a valid answer, of course): > > > > Do all queries from a single request use the same database > > connection? > > > > Obviously that's assuming all queries are to the same > > datasource. > > Yes, to the best of my knowledge, assuming the default > configuration options > in the CF Administrator also. > > > If the answer is yes, what about this question: > > > > Can multiple requests pass queries over the same database > > connection in a mixed order (request1query1 the > > request2query1, request1query2)? > > I don't know. I would assume not, but that's just an assumption. My > assumption is that database connections are held by a page until that page > is complete, then released back to the connection pool where they can then > be reused. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
