On: Stored Procedures as a Back End

[siscia]

> Performance hint: developers using cursors should have their hands cut off. This should do the trick.

What is wrong with cursor?

[unklefolk → siscia]

Performance basically. As SQL is a set based language you can often replace cursors (which are basically loops) with joins and that is orders of magnitude quicker for larger workloads.

[tehjoker → unklefolk]

Somehow I managed to avoid learning to use cursors and I have never seemed to need them. It seems like this was some kind of grace.