> 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=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
