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=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
