1. Not as portable between databases as SQL This one always comes up, my opinion on this one is, it hardly ever happens, when it does it means the clients have enough money to pay for a new db and throw away the old on that cost them thousands, thus they also have money to redevelop. Plus, I think not taking advantage of all the good stuff available to you just for the sake of portability, no way, its bad... Portability up to a certain level is good, but don't take it to far.
2. Harder to debug and test Stored Procedures are not hard to debug at all, most people who think so do not know about SP debugging in QA. 3. A little harder to maintain [editing SQL in a CF page is easier than editing a stored procedure in a DB] Don't need to edit it in the db, store them as .sql files and edit them with QA. 4. Need higher skilled developers to develop/maintain Agreed ;-)) 5. Hard to develop with unless you have complete control over the DB [ie some shared hosting environments may have restrictions on their use] ???? 6. May not give better performance ???? I think you have had to deal with some bad SPs in your life..... I feel for you ;-)) > Not that I'm saying you shouldn't use them but only use them when they will > give a benefit [usually performance]. > In general I've found that CFCs + CF code can encapsulate the business > logic better than using stored procedure but stored procedure can be used > to improved performance [esp for repetitive tasks or large loops over data] > where it is required. Everyone has his own opinion on this one, and I guess there is no wrong or right, for me its business logic in the db, CF is only to display and gather data as much as possible. > From experience having to fix a badly written sorted procedure is a lot > harder than trying to fix badly written cold fusion code ;-) > Justin ============================================= Justin Mclean Class Software Phone: (02) 93321230 9 Chapman St Fax: (02) 93321032 Surry Hills Mobile: 0416 119 342 NSW 2010 ============================================= --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 Register now for the 3rd National Conference on Tourism Futures, being held in Townsville, North Queensland 4-6 August - www.tq.com.au/tfconf --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
