I noticed that a good number of people like to use stored procedures (sproc’s). Personally, I don’t see the point. There’s not any performance boosts from using stored procedures. If you use query caching, the time benefits of having a stored procedure with a cached execution plan are not significantly more. It’s also a hassle coordinating the deployment of the stored procedures to the database with the code while hoping that no one will notice that small glitch between the two deployments. I could see using stored procedures if there’s some humongous query that you need to run, but that’s also a sign you need to rethink your database schema. What do you think?
