Alan K

Recent Blog Comments By Alan K

• ColdFusion CFQueryParam Binding vs. SQL Execution

  Posted on Jul 30, 2009 at 11:11 AM

  DonV69, Thanks for your response. While I did not update, eXcalibur.lk hit the nail on the head. It was a parameter conversion problem. Thanks for all. Alan... read more »

• ColdFusion CFQueryParam Binding vs. SQL Execution

  Posted on Jun 5, 2009 at 11:57 AM

  Yes I have, and without the CFQUERYPARAM, performance is consistent as seen when run directly in PLSQL/Developer. I ran it at the same time of two different web servers, with and without cfqueryparam, without was 15 seconds, with timed out.... read more »

• ColdFusion CFQueryParam Binding vs. SQL Execution

  Posted on Jun 5, 2009 at 10:56 AM

  Thanks for your quick responses. CFLOCK is not used. I'm not a ColdFusion developer, I'm the Oracle DBA. I work with 3 Cold Fusion Developers. I can extract the query out of ColdFusion, run it in pl/sql developer and it returns in about 15 seconds. I had suspected that it may be a JDBC issue. ... read more »

• ColdFusion CFQueryParam Binding vs. SQL Execution

  Posted on Jun 5, 2009 at 10:41 AM

  This is using ORACLE as the database... read more »

• ColdFusion CFQueryParam Binding vs. SQL Execution

  Posted on Jun 5, 2009 at 10:41 AM

  I'm having an issue where CFQUERY PARAM is slowing down the query to the point where using them the query times out, without them, it runs in 10-15 seconds. I've consistently seen this. Anyone hear of this?... read more »