> 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

Reply via email to