> So if cfqueryparam is using prepared statements (which my guess would be > that it's not), cfqueryparamming all of your variable values would improve > performance because the statement itself isn't being re-sent to the RDMS on > each subsequent query, only the values. But if it's not, it could actually > slightly DIMINISH performance ( because the SQL generated is more verbose > because of the variable declarations and binding syntax ).
Your guess is incorrect. CFQUERYPARAM builds a JDBC prepared statement. Using CFQUERYPARAM may improve or degrade performance, depending on additional factors. The SQL being more verbose is not one of those factors. 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321697 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4