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

Define the sanity testing, Sanity testing : - Sanity testing is used to ...

Sanity testing : - Sanity testing is used to make sure that multiple or conflicting functions or variables do not exist in the system. - It verifies that the components of th

What is a variant, What is a variant Ans) "Variants" are versions of a p...

What is a variant Ans) "Variants" are versions of a program.

Determine the process of software coding, Determine the process of software...

Determine the process of software Coding The input to coding phase is the SDD document. In this stage, design document is coded according to module specification. This phase t

What is stochastic testing, Stochastic testing is the similar as "monkey te...

Stochastic testing is the similar as "monkey testing", but stochastic testing is a lot more technical sounding name for the similar testing process.

What is dynamic analysis, The process of evaluating a program based on impl...

The process of evaluating a program based on implementation of that program. Dynamic analysis approaches rely on implementing a piece of software with selected test data.

Explain basic execution time model, Q. Explain Basic Execution Time Model? ...

Q. Explain Basic Execution Time Model? The model was developed by the J.D. MUSA in 1979(MUSA79) and is based on execution time. It is presumed that failures may occur according

Define cohesion and coupling, Q. Define cohesion and coupling? Give suitabl...

Q. Define cohesion and coupling? Give suitable examples. Ans Coupling: Coupling refers to the strength of the relationship between modules in a system. Coupling represents how

Assumptions of the execution-time component model, What are the assumptions...

What are the assumptions of the execution-time component model? The execution-time component is based on the several assumptions: (1) Tests show the environment in which the

Explain software process, Define software process. Software process is ...

Define software process. Software process is explained as the structured set of activities that are needed to develop the software system.

Database mapping, database mapping from class to database

database mapping from class to database

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