Jillian Koskie wrote:
> As a test I ran a few of my more sustantial SQL commands with and
> without cfqueryparam and it was faster without.
How many repetitions? How does the parsing, planning and execution time break
down?
Jochem
~~~
Counts on the code. Passing a list in should be slower. A date should be
faster.
> As a test I ran a few of my more sustantial SQL commands with and without
> cfqueryparam and it was faster without.
>
> I thought it was supposed to be faster WITH it?
>
>
~~
Usually, but not always. Most of us use it for It's security and defense
against sql injection attack. The speed improvement is sometimes a small bonus.
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
âââ¬ââ
â1â â
âââ¼ââ¤
â â