Interesting, indeed. Wonder if there's an issue of table scan vs index and how the initial execution plans are getting cached. Definitely something to keep your eye on!
>Interesting... >I thought the same thing until I ran these tests. I analyzed the results >with ColdFusion debugging output, the Server Monitor in CF8 Ent, SeeFusion, >and watched them execute through SQL Profiler, all of them showed better >execution times when I removed the CFQUERYPARAMs. Now, this was on a limited >subset of my queries. I would still argue that using it is far better than >not. Most of the Queries I have used it in I did see a performance >improvement in. > >=] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314618 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4