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 types of metrics, What are the types of metrics? Direct m...

What are the types of metrics? Direct metrics - It refers to right away measurable attributes. Example - Lines of code, execution speed. Indirect metrics - It refers

What is the value of a testing group, What is the value of a testing group?...

What is the value of a testing group? How do you justify your work and budget? Testing is a method used for revealing defects in s/w and for establishing that the s/w has attai

Describe the data abstraction, What does Data abstraction contains? A D...

What does Data abstraction contains? A Data abstraction is a named collection of data that describes a data object Eg: door Attributes: door type, Opening mechanism, Swing d

Explain the boundary value analysis, What is Boundary value Analysis? ...

What is Boundary value Analysis? Boundary value analysis is a method in software testing where tests are designed for showing boundary values. The values will be on the edge of

What is transform mapping, What is Transform mapping? The transform map...

What is Transform mapping? The transform mapping is a set of design steps applied on the DFD in order to map the transformed flow characteristics into exact architectural style

Software restructuring, Software restructuring Software restructuring c...

Software restructuring Software restructuring changes source code and / or data an effort to make it amenable to future changes. In general, restructuring does not change the o

Use case realization, Develop a domain model for the Case Study. Express yo...

Develop a domain model for the Case Study. Express your model with a class diagram, showing any inheritance and compositional relationships. For each of the two selected most es

What is the use of a data flow diagram, What is the use of a data flow diag...

What is the use of a data flow diagram? A data flow diagram is used to represent the functional view of an application domain. It represents all the significant business proces

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