Suitecrm custom workflow vs Mysql Store procedure

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hello,

Which with a better way to manage automation (when a new user is added in Suite CRM make a new entry in two-three custom modules I am thinking to make suite CRM workflow. Custom workflow slow down response ? or store procedures better way.

Antone, please give your suggestions and feedback?

Thanks

2

My personal opinion: avoid database triggers whenever it is possible.

you’ll find a lot of discussions like:
https://stackoverflow.com/questions/460316/are-database-triggers-evil

in the end, it’s your decision.

3

A database trigger/strored procedure is not good when you serious with managing CRM application.

a CRM application is huge growing nature, using triggers will kill whole application integrity. Here is main reasons.

  1. The application doesn’t know what happened end data and why it is changed.
  2. The application doesn’t know when it is going to changed.
  3. The application will not log anything, logger really helps to debug the application.

So my personal opinion is to maintain everything on application level. Don’t use trigger / stored proedures. Rest your choice!