I recently purchased O'Reilly's book, "MySQL Stored Procedure Programming" and found some interesting paragraph about half way through the book (yes I skipped a lot of it to get to that section). I'm not totally new to Stored Procedure's (certainly not an expert), but I rarely use them, which brings me to my question(s).
I'm in the process of launching a rather large application using CF7 and mySQL5. The application compiles a lot of metric data obtained from marketing accounts like Adwords, Bing, Yahoo as well as Analytical data from other software sources. I've got pretty much everything done with workflow and I'm in the process of Optimizing the pages using Query Caching and Indexing of some of the tables. I'm looking into the use of Stored Procedures and can't seem to decide. I have specific pages that use CFChart and supply many calculated metrics under that chart to display marketing trends to deliver an overall view of monthly, yearly, and even daily information. Would a Stored Procedure be better or faster in this case?? I've been reading that there are two schools of thought on the subject. Either use SP's all the time or don't. But that was written in 2006, am I missing somthing?? Any thought's, insights, or opinions would be greatly appreciated! Thanks, Matt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3255 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
