I've seen this behavior with long lists. The solution I've used was to write a MSSQL UDF that would convert the param'ed value into a table variable--which strangley resolves the issue.
-Dan On Monday, June 14, 2010, Matthew Lesko <m.le...@verizon.net> wrote: > > Wondered if anyone else had experienced this. I have an IN clause query which > runs in 500ms if I use cfqueryparam list="true". This same query runs in less > than 10ms if I pass the values directly (e.g. 'value1', 'value2', etc...). > > I've Googled around a bit and have the impression it's an issue with how the > statement is prepared on the db server, but couldn't find any solutions that > allowed for using cfqueryparam. > > Anyone have experience solving this problem? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
