> From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] > Is there any advantage having this type of query in a SP over > calling a simple CFC ??
Mike, Stored Procedures were a good choice for me when I was working at a place that had two, top-notch DBAs who could really analyze some of the more complex queries/transactions and optimize them for us (the developers) without us having to constantly go into the code to make changes, etc. We used inline queries for simple select, update, and delete statements; and used SPs for the complex tasks. Fast forward to where I work now where we have no DBA(s), anymore. I have two big internal apps that made heavy use of SPs which wasn't a problem when the DBAs were here. Since having to assume the DBA role as well, using SPs became a royal pain in the ass due to having to update so many areas, both in the application and on the DB server, everytime a change was made or a fix was necessary. Tango ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233858 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
