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 throw away prototype, Explain the Throw away prototype I...

Explain the Throw away prototype In this technique, prototype is discarded once its purpose is fulfilled and final system is built from scratch. Prototype is built quickly t

Discuss the problems faced during software maintenance, Q. Discuss the prob...

Q. Discuss the problems faced during software maintenance? The most significant problem during maintenance is that before correcting or else modifying a program the programmer

What does level0 dfd means, What does Level0 DFD means? Level0 DFD is c...

What does Level0 DFD means? Level0 DFD is called as 'fundamental system model' or 'context model'. In the context model the total software system is represented by a single bub

Short note on class, Class A class is a template that states the proper...

Class A class is a template that states the properties of objects. Classes have an interface which having of the operation, a body which executes the operations and instance va

What are quality factors, What are Quality factors? For large projects...

What are Quality factors? For large projects with 'average' capabilities, the development process verifies product quality. For small projects, the capabilities of the deve

What is verification represent, What is Verification represent? Verific...

What is Verification represent? Verification represents the set of actions that are performed to confirm that the software correctly implements the particular functionality.

What is software, What is Software Software is nothing but a collecti...

What is Software Software is nothing but a collection of computer programs that are related documents that are indented to give desired features, functionalities and good per

Difference between verification and validation, Difference between Verifica...

Difference between Verification and Validation Verification is Static whereas Validation is Dynamic. This means in Verification the s/w is inspected by looking into the code go

Explain some of the limitations of testing, Explain some of the limitations...

Explain some of the limitations of testing. Though testing is an significant part of system development and leads to a valid,  verified and efficient system, it also faces some

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