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 :(
> CF Geniuses, > > Please help! Here is my setup: > > CFMX 6.1 Updater 6 > Oracle 9i > DataDirect v3.3 Drivers or Oracle Database 10g Release 2 (10.2.0.3) > JDBC Drivers > > I am experiencing intermittent slowness when querying from tables that > have NCLOBs and the NCLOBs are part of the select clause. One query > in particular goes from taking ~400ms to ~82000ms in what appears to > be an intermittent, random pattern (at least, I have not found a way > to isolate the factors that cause it to behave one way or the other). > The same queries always return instantly when I use SQL*Navigator or > Toad and using the Oracle JDBC drivers. The problem appears to be > with ColdFusion. It is not isolated to one client or server, either; > all of our boxes/servers seem to have this problem (randomly). > > Here is what I have tried: > 1. Upgrade to latest DataDirect Drivers (v3.3) > 2. Use Latest Oracle thin drivers > 3. Muck around with datasource settings: > - Long Text / Blob size > - Maintain connections vs. not > - enable clob retrieval (I need this option checked, but I played w/ > it just in case) > - delete datasource and recreate > 4. Use cfqueryparam vs. no cfqueryparam > 5. Pull query out and run in sandbox file > 6. Rename query > 7. Change data that is being pulled back (seemed to happen more with a > particular set of data than another) > 8. Kick computer! > > These queries are a pivotal piece of our application and our release > is being held up because of it. Any help that can be provided would > be much, MUCH appreciated!! > > Thanks, > Austen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:285905 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
