What are the Advantages and disadvantages of Stored Procedure (SP)?

This article describes about the advantages and disadvantages of Stored Procedure (SP). Summary of the article:

  • Advantages of SP
  • Disadvantages of SP

sqlAdvantages of SP
The advantages of Stored Procedure (SP):

  • It is faster
  • It is Pre-compiled
  • It reduce network traffic
  • It is reusable
  • It can handle complex operation
  • It support nested SP
  • It’s security is high. No bode can see the code. Because it stay in Database Server

Disadvantages of SP
The disadvantage of Stored Procedure (SP):

  • Need expert developer, Because it is so hard to write code
  • It’s debugging is hard
  • It is not database independent. Its code may vary based on database server

That’s all about advantages and disadvantages of SP.

Leave a Reply

Your email address will not be published. Required fields are marked *