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

Defect amplification model with no review, How can we know about to divide ...

How can we know about to divide numbers from total error from which half passed through error and half passed to amplified and how to generate defect efficiency?

What is the value of a testing group, What is the value of a testing group?...

What is the value of a testing group? How do you justify your work and budget? Testing is a method used for revealing defects in s/w and for establishing that the s/w has attai

What is random testing, What is Random testing? Random testing is also ...

What is Random testing? Random testing is also referred as adhoc testing. As the tester can give the out of coverage data and the stability of an application is checked, whethe

Explain the incremental model, Explain the Incremental Model Iterative ...

Explain the Incremental Model Iterative and Incremental Models follow more or less the similar approach. Incremental Model is an intuitive approach to the waterfall model. Mult

How do software myths affect a software process, Q 1 Define a software proc...

Q 1 Define a software process. How do software myths affect a software process? Ans: A Software process is a Coherent set of activities for designing, specifying, implementin

Explain iterative development model in detail, Problem 1. Explain Itera...

Problem 1. Explain Iterative Development Model in detail 2. Explain the Incremental Development Model in detail 3. What are the major technical and non-technical factors whic

Illustrate detailed cocomo model, Q. Illustrate Detailed COCOMO model? ...

Q. Illustrate Detailed COCOMO model? Detailed COCOMO it incorporates all characteristics of the intermediate version with an assessment of the cost driver's impact on every ste

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