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 is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285889 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
