Simultaneous threads and maintain database connections
Is there a relationship between CF simultaneous requests and maintained database connections? Does a maintained database connection use one of the threads allocated for simultaneous requests? For example, suppose in Request Tuning I have simultaneous (Template) requests set to 10 and in CF data source settings I have Maintain Connections checked with Timeout set to 20 (minutes). A request completes. The database connection now is inactive and remains so for at least 20 minutes. CF maintains the connection to the database for 20 minutes. Does the maintained database connection also continue to hold on to the thread that was being used by the request that completed for the same 20 minutes? Or do the request thread and the database connection operate independently of each other? Thanks! George ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359168 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Simultaneous threads and maintain database connections
Hi, George! Is there a relationship between CF simultaneous requests and maintained database connections? No, not really. Does a maintained database connection use one of the threads allocated for simultaneous requests? No. Database connections use their own separate thread pool. The basic pooling mechanism is pretty similar, though. For example, suppose in Request Tuning I have simultaneous (Template) requests set to 10 and in CF data source settings I have Maintain Connections checked with Timeout set to 20 (minutes). A request completes. The database connection now is inactive and remains so for at least 20 minutes. CF maintains the connection to the database for 20 minutes. Does the maintained database connection also continue to hold on to the thread that was being used by the request that completed for the same 20 minutes? No. Or do the request thread and the database connection operate independently of each other? Yes, they're completely independent. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359169 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Simultaneous threads and maintain database connections
Hi back, Dave! Or do the request thread and the database connection operate independently of each other? Yes, they're completely independent. Thanks. This is what I always thought but I read something that made me think things might be otherwise. George ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359170 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
