> 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 ;-)
If you don't really care, why make the assertion? The database ALWAYS generates an execution plan, whether you use CFQUERYPARAM or not. CFQUERYPARAM simply makes it more likely that the database will be able to reuse an execution plan, as it makes that plan more general that it would otherwise be. > Understand me correctly, I never said that CFQP is NEVER > useful, I just don't like ayatollah statements like SHOULD *always*! Sometimes "always" is the right answer. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:309636 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
