May 23, 2024

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
  • 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.

Rashedul Alam

I am a software engineer/architect, technology enthusiast, technology coach, blogger, travel photographer. I like to share my knowledge and technical stuff with others.

View all posts by Rashedul Alam →

Leave a Reply

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