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 iterative enhancement model, Q. Explain Iterative Enhancement model...

Q. Explain Iterative Enhancement model? This model incorporates modification in the software based on the analysis of the existing system. As well the complete documentation of

Realistic approach to the development of large-scale systems, Q. Realistic ...

Q. Realistic approach to the development of large-scale systems? There are a number of advantages of Spiral model that makes it a realistic approach to development of large-sca

What is dfd, What is DFD? Data Flow Diagram depicts the information flo...

What is DFD? Data Flow Diagram depicts the information flow and the transforms that are applied on the data as it moves from input to output.

Threads, what resources are used when a thread is created ?

what resources are used when a thread is created ?

List the guidelines for data design, List the guidelines for data design. ...

List the guidelines for data design. i. Apply systematic analysis on data. ii. Determine data structures and related operations. iii. Establish data dictionary. iv. Us

Explain in detail about structural modeling, Explain in detail about Struct...

Explain in detail about Structural Modeling. Structural model having a detail refinement of ERD, data flow model and control flow model. Creating an ERD. Example: Saf

State lehmans first law, State Lehman's First law. A program that is u...

State Lehman's First law. A program that is used in true world environment essentially must change or become progressively less useful in that environment.

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