Cameron makes an excellent point here. Maintainability should be VERY high up on the priority list.
______________________________________________________________________ Ed Szwedo Web Development Team Lead ECS Team - ITS-EPA II Contractor 109 TW Alexander Drive, Building NCC, Mail Drop N176-05, Research Triangle Park, NC 27711 Information Technology Infrastructure Solutions | Office: (919)541-3955 | Fax: (919)541-3641 | [email protected] | www.ecs-federal.com From: Cameron Childress <[email protected]> To: [email protected] Date: 04/09/2012 01:44 PM Subject: Re: [ACFUG Discuss] Tricky SQL help? Sent by: [email protected] 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 | twitter | google+
<<inline: graycol.gif>>
