What are the benefits of using stored procedures, Software Engineering

Assignment Help:

What are the benefits of using Stored Procedures?

- They help in reducing network traffic and latency which in turn boosts application performance.

- They assist in promoting code reuse.

- They provide better security to data.

- It's possible to encapsulate the logic using stored procedures. This allows to change stored procedure code without affecting clients.

- It's possible to reuse stored procedure execution plans that are cached in SQL Server's memory. This decreases server overhead.

 


Related Discussions:- What are the benefits of using stored procedures

System analyst, Explain the role and functions of a Systems Analyst in the ...

Explain the role and functions of a Systems Analyst in the overall project development.

State the technique pilot used in software engineering, State the technique...

State the technique Pilot used in software engineering With this approach, new system is introduced into one part of the company (for example into one warehouse of a supermark

Stats free, system architecture block diagram

system architecture block diagram

What is affinity diagram, A group process that takes large quantity of lang...

A group process that takes large quantity of language data, like as a list developed by brainstorming, and separates it into categories.

What is equivalence partitioning, Equivalence Partitioning: -Equivalence pa...

Equivalence Partitioning: -Equivalence partitioning is black box testing method that separates the input domain of a program into classes of data from which test cases can be deriv

Graphical design notation, Explain any two graphical design notations used ...

Explain any two graphical design notations used in procedural design

#use case diagram, #use case diagram for car manufactures by considering bu...

#use case diagram for car manufactures by considering build and price of car as use case#

Explain logarithmic poisson execution time model, Q. Explain Logarithmic Po...

Q. Explain Logarithmic Poisson Execution Time Model? This model is as well developed by Musa et Al (MUSA79). The breakdown intensity function is different here as compared to B

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd