Stored procedures can offer performance gains when used instead of regular queries. This article will start with the basics and give you the complete overview on stored procedures and how to use them. Have you ever thought what happens when your queries get to the database?. They are actually compiled each time you query and then executed, but this is not the ideal approach. A much better option would be to have the database server compile the query, store it in a compiled format and run it on request, without having to recompile it each and every time. This is where the concept of stored procedures comes into play
|
