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 >
