On Mon, Apr 9, 2012 at 12:53 PM, Tepfer, Seth <[email protected]> wrote: > > Isn’t MySQL faster than CF at doing the select? If I can do it all in > one call, isn’t it better to make MySQL do the heavy lifting? >
Usually, yes. Spending 2 days writing a magical stored proc that will save you 50ms on a process isn't exactly a win if it only gets run once or twice a day. On the other end of the spectrum, if you're calling it 100 times a minute it might be worth it. I've seen plenty of projects where the team went completely overboard with SPs and cramming everything into the DB and ruined the app's maintainability as a result. You're really the only one on the list who can answer what the best solution is for your specific case. Balance and moderation are good. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook <http://www.facebook.com/cameroncf> | twitter<http://twitter.com/cameronc> | google+ <https://profiles.google.com/u/0/117829379451708140985>
