House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home / Groups / ColdFusion Talk (CF-Talk)

MS SQL and <cfqueryparam> slow-down

Author:
Christopher Watson
04/25/2012 01:18 PM

We've been profiling our MS SQL traffic, and we're seeing the occasional spike in execution times related directly to the operations that CF perform in relation to the <cfqueryparam> tag in getting table column details. The problem crops up only on <cfquery> tags where <cfqueryparam> is used for values, and the specific operation to get column details hangs the process up for up to 45 seconds. At this time, I'd like to ask if anyone else has seen this kind of behavior. Thank you!


Search cf-talk

May 18, 2013

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
       1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31   

Designer, Developer and mobile workflow conference