>>When your database executes a SQL statement, it generates an execution plan that best fits that statement and it caches that plan in memory for later use.
Ok, this is another example where CFQP is useful, as the doc says. But if the query is not likely to be executed often, which is the case with small sites, generating the execution plan might represent an overhead on the contrary. (just assuming, I have not run tests, and I don't really care ;-) Understand me correctly, I never said that CFQP is NEVER useful, I just don't like ayatollah statements like SHOULD *always*! -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309635 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
