DEV Community

loading...

Discussion on: When is it a good idea to use stored procedures?

Collapse
perigk profile image
Periklis Gkolias • Edited

For me, it is right when it doesn't contain business logic. Or if speed is absolutely critical.

For example:

  • Auditing an action or a data change
  • Archiving data
  • For cron-like tasks