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

Need of output comparators, Q. Need of Output comparators? Output comp...

Q. Need of Output comparators? Output comparators These are used in dynamic testing-both single-module and multiple-module (system level) varieties to check that predicted an

How to compute the cyclomatic complexity, How to compute the cyclomatic com...

How to compute the cyclomatic complexity? The cyclomatic complexity can be computed by any one of the following ways. 1. The numbers of regions of the flow graph correspond

What is walk-through, A walk-through is an informal meeting for information...

A walk-through is an informal meeting for informational purposes or evaluation.

Define data dictionary, Define Data Dictionary The data dictionary can ...

Define Data Dictionary The data dictionary can be explained as an organized collection of all the data elements of the system with precise and rigorous definitions so that user

Explain bottom-up integration, Bottom-up integration This testing start...

Bottom-up integration This testing starts construction and testing with the components at the lowest levels in the program structure.

What is data modelling, What is data modelling? Data modeling is the ba...

What is data modelling? Data modeling is the basic step in the examine modeling. In data modeling the data objects are examined independently of processing. The data model s

Explain the test case, Test Case A test case is a unit level document d...

Test Case A test case is a unit level document describing the inputs, steps of implementation and the expected result of each test condition for each requirement from the BRD.

What is requirements engineering, What is Requirements Engineering Req...

What is Requirements Engineering Requirements engineering is systematic use of proven techniques, principles and language tools for cost effective analysis, on-going evaluatio

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