MySQL Forums
Forum List  »  Stored Procedures

Best Practices
Posted by: Benoit St-Jean
Date: October 04, 2018 10:27PM

I was thinking of having all "common functions" used by all users on my server stored into a "common database" instead of creating the same functions over & over in every database. Pros? Cons? Performance issues?

Any recommendations as if this makes sense? Best practices?

From a maintenance standpoint, having to modify just one version of a function seems to be easier than having to recreate the "corrected" function in every database.

Does this make sense at all?

Options: ReplyQuote


Subject
Views
Written By
Posted
Best Practices
150
October 04, 2018 10:27PM
83
October 05, 2018 09:32AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.