Having multiple ways to achieve a task is something we all enjoy
as developers and DBAs. We find, develop and learn new ways to do
things better and faster all the time.
At the risk of starting a debate, I am curious on others opinions
or practices when it comes to Stored Procedures and Triggers. To
use them or not versus code based functions ? Best case use
versus worst case use? There is no real wrong answer here as it
depends on your development application. Certainly some lean one
way over another and there are more than enough valid reasons on
both sides of the debate.
Here are couple of my thoughts on the topic....
I come from the dot.com bubble era , and from that I rarely use
stored procedures or triggers. Back then PHP was still new, Perl
dominated websites with the cgi-bin and MySQL did not have stored
procedures or triggers. Thank goodness things have changed.
Developing in those days, forced developers to …
Showing entries 1 to 1
Jul
05
2011
Showing entries 1 to 1