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 various software risks, Explain various Software risks.  Typic...

Explain various Software risks.  Typical Software Risks:- 1. Dependencies: -Many risks arise because of dependencies of project on outside  agencies or factors. It is not

Explain dynamic testing, Verification or validation performed which impleme...

Verification or validation performed which implements the system's code.

What is a data object, What is a data object? Data object is a collecti...

What is a data object? Data object is a collection of attributes that act as an aspect, characteristic, quality, or descriptor of the object.

Differentiate between smoke testing and sanity testing, Differentiate betwe...

Differentiate between smoke testing and sanity testing. -Smoke testing verifies all areas of application; sanity testing recognizes one or few areas only. -Smoke testing is

Simulate the operations of a scientific calculator, Q. A program is to be d...

Q. A program is to be developed to simulate the operations of a scientific calculator. List the facilities to be provided by this calculator. Analyze this using DFD? Level 0

Illustrate the introduction to flowcharts, Illustrate the Introduction to F...

Illustrate the Introduction to Flowcharts This mainly covers four areas: 1 Common flow chart symbols 2 Writing flowcharts to solve problems 3 Dry running of flowcharts

What is desk checking, What is Desk Checking? Ans) A type of manual stat...

What is Desk Checking? Ans) A type of manual static analysis usually performed by the originator. Source code documentation, etc., is visually checked against needs and standard

Different type of testing tools, Different type of testing tools. (a) T...

Different type of testing tools. (a) Test Case Generators: (b) Capture/ Playback and Test harness tools: (c)  Coverage Analysis Tools: (d) Test Comparators e) Memor

Creating the field selection table - database definition, Creating the Fiel...

Creating the Field Selection Table (FST) : Entering of data and creating indexes for searching is a very important feature associated with any information storage and retriev

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