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

The software life cycle model that incorporates risk factor, Explain the so...

Explain the software life cycle model that incorporates risk factor.  The problem with traditional software process models is that they do not deal adequately with the uncertai

Cocomo 81 estimation model, You are preparing a bid for a refinery control ...

You are preparing a bid for a refinery control system for Australian Petroleum Ltd (APL) using the CoCoMo 81 estimation model. You are familiar with industrial control system softw

Software configuration management , Software configuration management is a...

Software configuration management is an umbrella activity which is applied by the software procedure. SCM identifies controls, audits and reports modifications that invariably occ

Types of debugging techniques used in software testing, Name the types of ...

Name the types of debugging techniques used  in Software testing.   various debugging techniques are:- 1) Core dumps 2) Traces 3) Print statements 4) Debugging pr

What is closed box testing, Closed box testing is similar as black box test...

Closed box testing is similar as black box testing. Black box testing a type of testing that examine only externally visible behavior.

Give the overview of application software, Question 1 Give the classificat...

Question 1 Give the classification of computers and explain them briefly Question 2 Give the overview of application software Question 3 Explain the three main types of

Explain sanity testing, Sanity testing is performed whenever cursory testin...

Sanity testing is performed whenever cursory testing is sufficient to show the application is functioning according to specifications. This level of testing is a subset of regressi

Black box and white box testing, I am not properly understanding the basis ...

I am not properly understanding the basis difference between black box testing and white box testing. Please explain in simple way and with some example so that I can easily under

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