Just a thought, but it might help you to use SeeFusion to get a thread dump of CF "twiddling it's thumbs" to see what it is really doing.
-----Original Message----- From: austen rustrum [mailto:[EMAIL PROTECTED] Sent: Thursday, August 09, 2007 6:09 PM To: CF-Talk Subject: Re: Intermittent slowness when selecting from tables that have NCLOBs I forgot to add something. I used Wireshark to analyze network traffic for one of my queries that is intermittently taking ~17000ms. It appears that the database finishes sending its last packet (which is acknowledged) and then there is about a 15 second delay before I get my 200/OK HTTP response sent. So apparently ColdFusion is having a grand old time twiddling its thumbs or something. I don't get it :( ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
