Answer by jfar for Stored Procedures – End of days.

Answer by jfar for Stored Procedures – End of days.
StackOverflow.com –

Bah!

ORM, SPs, View, Magic Wands, or whatever.

Each “tool” has its place in your belt, use the tools you have wisely.

The only thing that has “changed” ( really improved ) is that some ORMs have nice caching tools already baked in and MySql and Sql 2005+ can handle dynamic or ad hoc query/execution plan caching.

The potential performance loss from throwing the all sorts of dynamic sql at your db server has been somewhat mitigated. Its just easier to go without stored procedures now. Stored Procs aren’t going anywhere.

This entry was posted on Monday, February 09th, 2009 and is filed under StackOverflows. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.