Why Stored Procedure? Drawbacks of using queries in Stored Procedure in asp dot net
Why Stored Procedure? Drawbacks of using queries in Stored Procedure in asp dot net : in asp dot net lot of people taking about Stored Procedure but many people don't know about Stored Procedure so here we give importance of Stored Procedure in asp dot net and also give details about why Stored Procedure ? ,Drawbacks of using queries ?
Drawbacks of using
queries
- More burden on the database.
- Performance of the Application is reduced.
- User gets delayed response.
- Possibility of Sql Injection attacks.
- No re usability facility.
Why
Stored Procedure?
- It’s implemented by the several criteria i.e. Usability, Scalability, Integrity, Extensibility, Security & Availability.
- There is No possibility of Sql Injection Attacks.
- Re usability facility is there.
0 comments:
Post a Comment