> 1. I believe stored procs are generally faster than sending the > same query to SQL Server due to query optimisation(?)
The only query optimization that goes on is the building of an execution plan. Using conditional logic in a stored procedure can have very harmful effects on the reusability of an execution plan. I'd rather have multiple queries, each with its own optimal execution plan, than one stored procedure with a potentially suboptimal execution plan. > 2. Less data is being sent to the SQL server In most cases, this is trivial. > 3. Less CF application process before the code is run on the SQL > server .... weighed against more SQL application process after the code is run on your CF server. > Would you think otherwise? I think it's very dangerous to attempt predictions of performance based on what "feels right" to us, as we often do. Very often, in my experience, load testing tends to overturn those predictions. 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
