mdsupport wrote on Wednesday, August 25, 2010:
Are there development standards relating to use of MySQL stored procedures?
bradymiller wrote on Wednesday, August 25, 2010:
hey,
This topic was touched on in the thread:
https://sourceforge.net/projects/openemr/forums/forum/202506/topic/3532190
The conclusion is that it’s not a good idea to use stored procedures, primarily because it will not allow the option of database portability (postgresql etc.) in the future and also some web site providers do not allow installation of mysql procedures. As you see in the above thread, that module could not be introduced into the main openemr program (is an optional feature to install) because it used stored procedures.
-brady