Re: Slow cfqueryparam IN clause on SQL Server 2008

2010-06-14 Thread Dan G. Switzer, II
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 wrote: > > Wondered if anyone else had experienced this. I have

Re: Slow cfqueryparam IN clause on SQL Server 2008

2010-06-14 Thread Jim Eisenhauer
Can you provide more of a snippet of code? Jim Eisenhauer On Mon, Jun 14, 2010 at 9:54 AM, Matthew Lesko 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 pa

Slow cfqueryparam IN clause on SQL Server 2008

2010-06-14 Thread Matthew Lesko
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