2

Why do some hosting services with MySQL not allow triggers and stored procedures / functions?
Had never tried to use them and now I've done it and deployed a site, I discover I can't create triggers, and that some hosting provider don't allow users to do them... this is a rant but more of a question, as I didn't know and maybe there's lore to it you do know...

Comments
  • 2
    Sprocs and functions: permissions
    Triggers: That potentially allows you to turn their db into a worker, and they can't control the amount of work you put into them. Their pricing model is based on the instructions, events originating in your system.
Add Comment