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

Difference between pilot and beta testing, Difference between Pilot and Bet...

Difference between Pilot and Beta Testing. Pilot testing includes having a group of end users try the system prior to its full deployment in order to give feedback on its perfo

Advantages and disadvantages of size measure, What are the advantages and d...

What are the advantages and disadvantages of size measure? Advantages: Artifact of software development which is simply counted. Many existing methods use LOC as a key input. A

Explain predictive validity, Q. Explain Predictive validity? Predictiv...

Q. Explain Predictive validity? Predictive validity: It is the potential of the model to predict future failure behaviour from present and past failure behaviour. This capabi

Why is maintenance of a software important, Q. Why is maintenance of a soft...

Q. Why is maintenance of a software important? Discuss some of the problems that are faced during maintenance of software. Ans: The modification of a software product subsequ

Develop a test case for any under development application, An application w...

An application which is under development. How would you develop a test case for it? When application is under development, Business Requirement Document is used as primary doc

What are the misunderstanding arises in software development, What are the ...

What are the misunderstanding arise in software development Some of the common misunderstandings regarding software development are given below. 1.  Correcting errors is eas

Network Technology, How can you create a file named -i? Which techniques do...

How can you create a file named -i? Which techniques do not work, and why do they not work? How can you remove the file named -i?

Software requirements analysis, What types of models are formed during soft...

What types of models are formed during software requirements analysis?   Functional and behavioral

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