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

What are the phases of problem solving loop, What are the phases of Problem...

What are the phases of Problem solving Loop? Problem definition identifies the problem to be resolved. Technical development helps to resolve the Problem through various Te

Illustrate exploratory testing, Illustrate exploratory testing. - In ex...

Illustrate exploratory testing. - In exploratory testing approach testers are involved in maximum test execution and minimum planning. - Planning includes creation of a test

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

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

What is a document version, What is a document version? Ans) A document ...

What is a document version? Ans) A document version is a first release (or complete re-release) of a document, as opposed to a revision resulting from issuing change pages to a

Explain in brief the concept of functional independence, Explain in brief t...

Explain in brief the concept of Functional independence ?

Program input initiated interpput, what are the basic advantages of using i...

what are the basic advantages of using interrput-initiated data transfer over transfer under progrm control without an interrput

Explain respiratory quotient, Explain Respiratory quotient? Ans) Respira...

Explain Respiratory quotient? Ans) Respiratory quotient is the ratio among the carbon-dioxide used in photosynthesis to the quantity of oxygen liberated in respiration.

What is structure chart, Q. What is Structure chart? A structure chart ...

Q. What is Structure chart? A structure chart is a top-down modular design tool construct of squares representing the different modules in the system as well as lines that conn

What are dynamic testing tools, Q. What are dynamic testing tools? Explain ...

Q. What are dynamic testing tools? Explain the functions that they must support. Ans. Dynamic testing tools: 1: coverage analyzers (execution verifiers): A coverage anal

Explain equivalence class partitioning, Q. Explain Equivalence Class Partit...

Q. Explain Equivalence Class Partitioning ? Equivalence Class Partitioning : It is a method in black box testing. It is designed to reduce the number of test cases by dividing

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