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
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
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
3 matches
Mail list logo