Is Cold Fusion REALLY multi threaded?
Please, someone tell me that there is a configuration option I have wrong. If I execute a killer query (one that takes, say 2 mins for the database to return the result set) from a coldfusion page, then all other cold fusion users are left hanging until the query has returned it's result set.. If, however, I execute the same query from the database client, it still takes the same amount of time to return the result set, but has no discernable effect on the response times of the coldfusion users. This suggests to me that CF only executes one DB query at a time - please tell me I'm wrong. This also explains why our system response times are so lame when there are more than about 20 people on line For the record, the applicable CF Admin settings ara: - Single Threading: not checked - Variable Scope Lock settings: all set to no automatic checking or locking Is there anything else I need to set? Environment: Op Sys: linux Red Hat Linux 2.4.2 CF v5.0 Unix ODBC Postgres 7.2.3 database - Stephen Richards 020 7903 3226 --
RE: Is Cold Fusion REALLY multi threaded?
Yes, ColdFusion Server is multithreaded; AFAIK, CF does not simply call one DB call at a time, that would be utterly ridiculous and a waste of time! What are your servers specs? Memory etc..? Neil -Original Message- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 10:15 To: CF-Talk Subject: Is Cold Fusion REALLY multi threaded? Please, someone tell me that there is a configuration option I have wrong. If I execute a killer query (one that takes, say 2 mins for the database to return the result set) from a coldfusion page, then all other cold fusion users are left hanging until the query has returned it's result set.. If, however, I execute the same query from the database client, it still takes the same amount of time to return the result set, but has no discernable effect on the response times of the coldfusion users. This suggests to me that CF only executes one DB query at a time - please tell me I'm wrong. This also explains why our system response times are so lame when there are more than about 20 people on line For the record, the applicable CF Admin settings ara: - Single Threading: not checked - Variable Scope Lock settings: all set to no automatic checking or locking Is there anything else I need to set? Environment: Op Sys: linux Red Hat Linux 2.4.2 CF v5.0 Unix ODBC Postgres 7.2.3 database - Stephen Richards 020 7903 3226 -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Is Cold Fusion REALLY multi threaded?
Stephen Richards wrote: For the record, the applicable CF Admin settings ara: - Single Threading: not checked - Variable Scope Lock settings: all set to no automatic checking or locking Is there anything else I need to set? For the datasource, what do you have for Limit simultaneous connections and what is your CF setting for simultaneous requests? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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
Re: Is Cold Fusion REALLY multi Threaded?
Date: Thu, 05 Dec 2002 11:41:28 +0100 From: Jochem van Dieten [EMAIL PROTECTED] Subject: Re: Is Cold Fusion REALLY multi threaded? Message-ID: [EMAIL PROTECTED] Stephen Richards wrote: For the record, the applicable CF Admin settings ara: - Single Threading: not checked - Variable Scope Lock settings: all set to no automatic checking or locking Is there anything else I need to set? For the datasource, what do you have for Limit simultaneous connections and what is your CF setting for simultaneous requests? Jochem Limit connections is not checked, however the value is 0. SR
RE: Is Cold Fusion REALLY multi threaded?
Date: Thu, 5 Dec 2002 10:25:39 - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] Subject: RE: Is Cold Fusion REALLY multi threaded? Message-ID: AFDBA0DE939BD41195290008C7A448A96234EE@RECCSDEXC2 Yes, ColdFusion Server is multithreaded; AFAIK, CF does not simply call one DB call at a time, that would be utterly ridiculous and a waste of time! What are your servers specs? Memory etc..? Neil Good spec: dual P3 1.2 GHz processeor, 1 GByte RAM, loads of RAID disk - Stephen Richards 020 7903 3226 --
Re: Is Cold Fusion REALLY multi Threaded?
Stephen Richards wrote: Limit connections is not checked, however the value is 0. OK, next step is to check the number of database connections you actually have. Easiest is if you are only using one datasource on that particular server, just run a netstat and check the number of TCP connections to port 5423. Else, start working from the database side, use the standard tools to determine the number of backends and their status. Alsomake sure you are not running with a default transaction level of serializable, which would make all transactions run pretty much after eachother. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Is Cold Fusion REALLY multi threaded?
Another thing to check, in Select queries are you using the Blockfactor = x (x being a number between 1 and 100). Using Blockfactor causes CF to bring back blocks of results. Mike Brunt - CTO Webapper Services LLC Blog - http://www.webapper.net Downey CA Office 562.243.6255 AIM webappermb Web Application Specialists -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:26 AM To: CF-Talk Subject: RE: Is Cold Fusion REALLY multi threaded? Yes, ColdFusion Server is multithreaded; AFAIK, CF does not simply call one DB call at a time, that would be utterly ridiculous and a waste of time! What are your servers specs? Memory etc..? Neil -Original Message- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 10:15 To: CF-Talk Subject: Is Cold Fusion REALLY multi threaded? Please, someone tell me that there is a configuration option I have wrong. If I execute a killer query (one that takes, say 2 mins for the database to return the result set) from a coldfusion page, then all other cold fusion users are left hanging until the query has returned it's result set.. If, however, I execute the same query from the database client, it still takes the same amount of time to return the result set, but has no discernable effect on the response times of the coldfusion users. This suggests to me that CF only executes one DB query at a time - please tell me I'm wrong. This also explains why our system response times are so lame when there are more than about 20 people on line For the record, the applicable CF Admin settings ara: - Single Threading: not checked - Variable Scope Lock settings: all set to no automatic checking or locking Is there anything else I need to set? Environment: Op Sys: linux Red Hat Linux 2.4.2 CF v5.0 Unix ODBC Postgres 7.2.3 database - Stephen Richards 020 7903 3226 -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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
Fw: Is Cold Fusion REALLY multi threaded?
Yes, I agree with you, we are denormalizing like mad and retuning the database, and am confident that we will get the two minute query down to something more manageable. yes, the CPU maxes out at 99.9% while the query is executing. However, that doesn't alter the fact, that if the query is executed from a CF page, then all other CF activity comes to a halt; if it is executed from the db client command line, then other CF activity (includeing Db accesses) work just dandy. - Stephen Richards 020 7903 3226 -- - Original Message - From: S V [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 3:11 PM Subject: Re: Is Cold Fusion REALLY multi threaded? I know that you may have already done this, but check the tables thems selves. Are they properly tuned, Indexes, If there are multi joins, maybe they need to be denormalized. On the CF query get a limited number of rows , instead og XXX million rows. Is the CPU peaked on this page??? = = = Original message = = = Please, someone tell me that there is a configuration option I have wrong. If I execute a killer query (one that takes, say 2 mins for the database to return the result set) from a coldfusion page, then all other cold fusion users are left hanging until the query has returned it's result set.. If, however, I execute the same query from the database client, it still takes the same amount of time to return the result set, but has no discernable effect on the response times of the coldfusion users. This suggests to me that CF only executes one DB query at a time - please tell me I'm wrong. This also explains why our system response times are so lame when there are more than about 20 people on line For the record, the applicable CF Admin settings ara: - Single Threading: not checked - Variable Scope Lock settings: all set to no automatic checking or locking Is there anything else I need to set? Environment: Op Sys: linux Red Hat Linux 2.4.2 CF v5.0 Unix ODBC Postgres 7.2.3 database - Stephen Richards 020 7903 3226 -- ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail
Fw: Is Cold Fusion REALLY multi threaded?
That is interesting. However, I wonder just what effect it will have in this case, because the long page is executing a SERIES of 6 long queries (it is producing a page of stats), and all CF activity stops until all six queries have been executed. If the blockfactor was going to release the CF server to work on something else for a while, you would also expect a change from one query to another, no? I'll try it and let you know. - Stephen Richards 020 7903 3226 -- - Original Message - From: Mike Brunt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 3:37 PM Subject: RE: Is Cold Fusion REALLY multi threaded? Another thing to check, in Select queries are you using the Blockfactor = x (x being a number between 1 and 100). Using Blockfactor causes CF to bring back blocks of results. Mike Brunt - CTO Webapper Services LLC Blog - http://www.webapper.net Downey CA Office 562.243.6255 AIM webappermb Web Application Specialists -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:26 AM To: CF-Talk Subject: RE: Is Cold Fusion REALLY multi threaded? Yes, ColdFusion Server is multithreaded; AFAIK, CF does not simply call one DB call at a time, that would be utterly ridiculous and a waste of time! What are your servers specs? Memory etc..? Neil -Original Message- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 10:15 To: CF-Talk Subject: Is Cold Fusion REALLY multi threaded? Please, someone tell me that there is a configuration option I have wrong. If I execute a killer query (one that takes, say 2 mins for the database to return the result set) from a coldfusion page, then all other cold fusion users are left hanging until the query has returned it's result set.. If, however, I execute the same query from the database client, it still takes the same amount of time to return the result set, but has no discernable effect on the response times of the coldfusion users. This suggests to me that CF only executes one DB query at a time - please tell me I'm wrong. This also explains why our system response times are so lame when there are more than about 20 people on line For the record, the applicable CF Admin settings ara: - Single Threading: not checked - Variable Scope Lock settings: all set to no automatic checking or locking Is there anything else I need to set? Environment: Op Sys: linux Red Hat Linux 2.4.2 CF v5.0 Unix ODBC Postgres 7.2.3 database - Stephen Richards 020 7903 3226 -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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
RE: Is Cold Fusion REALLY multi threaded?
Subject: Is Cold Fusion REALLY multi threaded? Yes, it really is. If I execute a killer query (one that takes, say 2 mins for the database to return the result set) from a coldfusion page, then all other cold fusion users are left hanging until the query has returned it's result set.. If, however, I execute the same query from the database client, it still takes the same amount of time to return the result set, but has no discernable effect on the response times of the coldfusion users. This suggests to me that CF only executes one DB query at a time - please tell me I'm wrong. This also explains why our system response times are so lame when there are more than about 20 people on line. This may be a problem with your specific database drivers. I'm not especially familiar with PostgreSQL, but I've seen similar things in the (relatively distant) past with Oracle ODBC drivers - they were essentially single-threaded, so all queries were queued - which, as you've discovered, is very bad for performance! 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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
