Search code examples
mysqlsql-serverdatabaseoffloading

what exactly does it mean to not do work in the database if we can do it elsewhere?

http://www.percona.com/ppc2009/PPC2009_Boring_MySQL.pdf:

Don't do work in the database if you can do it elsewhere

I must say I don't quite understand this statement. Can someone elaborate on it?

Does it mean the we should enforce integrity on the application level instead of at the database level?

Or does it mean something else completely?

Solution

  • We have no way of knowing. The only person who knows what he meant by that is the author, Baron Schwartz. A quick scan of his slides suggests he isn't an idiot, so I'm pretty sure he doesn't mean enforce integrity in the application not the database. He probably means don't overload the database with other processing that can be done more efficiently elsewhere.