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

Explain the empirical estimation models, Write short notes on empirical est...

Write short notes on empirical estimation models. Estimation model for computer software uses empirically derived formulas to expect effort as a function of line of codes (LOC)

Explain smoke testing, Explain Smoke testing - Smoke testing covers all...

Explain Smoke testing - Smoke testing covers all of the fundamental functionality of application. - It is considered as the main test for checking the functionality of appli

What is a user guide, The "user guide" is the similar as the user manual. T...

The "user guide" is the similar as the user manual. The user guide is a document that shows information essential to employ a system or component to get the desired results. Typica

What is syntax, 1) The relationship between characters or groups of charact...

1) The relationship between characters or groups of characters independent of their meanings or the manner of their interpretation and use; 2) The formation of expressions in a

Demonstrate the sequence of prototyping, Demonstrate the Sequence of protot...

Demonstrate the Sequence of prototyping Sequence of prototyping is demonstrated in following Figure.

What is code restructuring, Q. What is Code Restructuring? Code Restru...

Q. What is Code Restructuring? Code Restructuring : It is performed to acquiesce a design that produces the same function but with higher quality than the original program. Ge

Explain network switching subsystem in gsm, Question: (a) (i) What are...

Question: (a) (i) What are the main components of the Network Switching Subsystem in GSM? (ii) What are the main functions of the Network Switching Subsystem? (b) What

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

What is the use of cmm, What is the use of CMM? Capability Maturity Mod...

What is the use of CMM? Capability Maturity Model is used in assessing how well an organisation's processes permit to complete and manage latest software projects.

Data Mining Question, This assignment uses the data set rent.txt, the Housi...

This assignment uses the data set rent.txt, the Housing Rent Prices in Munich file available at ">http://www.interactivegraphics.org/Datasets.html. 1.Produce a scatterplot of Re

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