Hello,

I am beginning to using MySQL stored procedures in a production
environment. Being as open ended as possible, I was hoping people here
could give me general best practices for using stored procedures.
Naming convention and argument usage are the most prominent issues I
am currently trying to determine, but there are also issues like
maintenance, upgrading, and performance tuning. For example, is it
insane to place version numbers in procedure names to try to prevent
issues when upgrading widely used procedures? Are there things to keep
in mind in striving for more efficient or faster procedures?

If you have any pointers, please send them my way.