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 is product metrics, Product metrics: explain the characteristics of t...

Product metrics: explain the characteristics of the product such as size, complexity, design features, performance, efficiency, reliability, portability, etc.

Software development plan , Phone Company (WLPC) is a provider of wireless ...

Phone Company (WLPC) is a provider of wireless phone service in the US with 100,000 customers serving mostly small markets. WLPC has just purchased additional airwaves in the US, C

Mention some of the drawbacks of rad model, Mention some of the drawbacks o...

Mention some of the drawbacks of RAD model. Not suitable for largescale projects. Commitment of developers & customers are required. Not appropriate when technical ris

Software Metircs, I have a comprehensive question for Software Metrics ...i...

I have a comprehensive question for Software Metrics ...it is 16 question

What is stochastic testing, Stochastic testing is the similar as "monkey te...

Stochastic testing is the similar as "monkey testing", but stochastic testing is a lot more technical sounding name for the similar testing process.

Determine the technique - parallel, Determine the technique - Parallel ...

Determine the technique - Parallel With this approach, old and new systems are run together for a time  -  If new system goes down for any reason, you still have old system

Explain the use of scm process, Question 1 Explain the origin of the defec...

Question 1 Explain the origin of the defect distribution in a typical software development life cycle Question 2 Explain the concept of quality Question 3 Explain the contents

Define the prototyping model, Define the Prototyping Model In this mod...

Define the Prototyping Model In this model, a working model of actual software is developed originally. Prototype is just like a sample software having low reliability and les

Nature and types of softare packages, NATURE AND TYPES OF SOFTARE PACKAGES:...

NATURE AND TYPES OF SOFTARE PACKAGES: Software packages are commercially supplied products which typically provide solutions to a particular range of software development or a

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