I've always been a believer in avoiding sql procedures, for the main
reason that I want to be as database-independent as possible. I know it
is less efficient, but being able to switch between MySQL, Postgre, and
the new freebies from IBM, Oracle, and Microsoft is a strong advantage
from the business perspective (of total cost to the customer, and
Of course, this is a discussion point. I'd love to hear from the
community on their experiences.
> I'd also like to add that if you have a choice between doing
> something in the application logic vs. MySQL's SQL
> statements, then it is probably more efficient to use SQL
> statements, constructs and related functions, to get the job
> done, rather than in the application logic if possible.