It could be that you are not indexing the columns you're using variable data to search on.
~ Mike Stemle, jr. On Apr 25, 2012, at 12:18, Christopher Watson <skyg...@gmail.com> wrote: > > 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! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350834 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm