Frans, thought you'd like this thread on Hacker News since you're such a fan of stored procs

http://news.ycombinator.com/item?id=2832246

Oh boy, is that debate still going on ?

Anyway, stored procs for CRUD... not really ideal IMHO. Though some stored procs are better, i.e. when you have to consume a lot of data to produce a small resultset. This is more efficient in the db (so in a proc) as it doesn't have to retrieve a lot of data from the database to the client.

From the looks of it, the debate rehashes all the same points debated already to death so many times...