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

How messages can be used in software engineering, Q. How Messages can be us...

Q. How Messages can be used in software engineering? Messages:- The interaction or communication between the different objects and classes is done by passing messages. The ob

List any characteristics of a good srs, List any three characteristics of a...

List any three characteristics of a good SRS. Ans:The SRS should be: Correct , Unambiguous, Complete 1. Correct: An SRS is correct if each requirement stated therein is on

The functional requirement for a library management system, Describe the fu...

Describe the functional requirement for a Library management system ?

What is recovery/error testing, Recovery/error testing is testing how well ...

Recovery/error testing is testing how well a system recovers from crashes, hardware failures, or other catastrophic problems.

What is the use of a data flow diagram, Q. What is the use of a data flow d...

Q. What is the use of a data flow diagram? Explain the important concepts of data flow diagram. Ans. A data flow diagram is utilized to show the functional view of an applica

What is evolutionary prototype, Evolutionary Prototype In this, prot...

Evolutionary Prototype In this, prototype is constructed to learn about software problems and their solutions in successive steps. Prototype is initially developed to satisf

Explain top down design, Top down design: A top down design approach begin...

Top down design: A top down design approach begins by identifying the main modules of the system, decomposing them into their lower level modules and iterating unless the desired

Artificial intelligence, Explain fully the application of artificial intell...

Explain fully the application of artificial intelligence

Describe design walk throughs and critical design review, Q. Describe desig...

Q. Describe design walk throughs and critical design review? Ans. A design walkthrough is a excellence practice that allows designers to acquire an early validation of desig

What are the various kinds of system testing, What are the various types of...

What are the various types of system testing? 1. Recovery testing - is intended to check the system's capability to recover from failures. 2. Security testing - verifies tha

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