I would agree...unless it is a really, really complex query that is just killing performance...I try and avoid SP's...they make life so much harder for debugging. I haven't jumped into ORM land yet...it's on the list.
------------------------------------ Three Ravens Consulting Eric Roberts Owner/Developer ow...@threeravensconsulting.com tel: 630-486-5255 fax: 630-310-8531 http://www.threeravensconsulting.com ------------------------------------ -----Original Message----- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Monday, December 03, 2012 9:28 AM To: cf-talk Subject: Re: Can this be improved On Sat, Dec 1, 2012 at 4:43 PM, Bruce Sorge <sor...@gmail.com> wrote: > I did not use stored procs because I have having issues with making > them on MySQL since I am new to the db, so I know that is one > improvement that I could make. > In addition to casey's comments, I would generally say that using Stored Procs is usually NOT an improvement. they don't usually give you a measurable performance gain, nor a security gain. They just end up making your code less maintainable since you have to maintain things in two places (the DB and CF code) instead of just one place (CF code). They also make your code less portable. ORM, on the other hand, makes your code WAY WAY WAY more portable, and (once you are past the learning curve) much faster to do development and easier to maintain. -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> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm