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

Artificial intelligence, what are the characteristics of artificial intelli...

what are the characteristics of artificial intelligence

What are the parameters of performance testing, The term "performance testi...

The term "performance testing" is usually used synonymously with stress testing, load testing, reliability testing, and volume testing. It is a part of system testing, but it's als

Explain debugging, The act of attempting to verify the cause of the symptom...

The act of attempting to verify the cause of the symptoms of malfunctions noticed by testing or by frenzied user complaints.

Information engineering, Information engineering is a system  engineering ...

Information engineering is a system  engineering approach which is used to describe architectures which enable a business to use data professionally. The intent of information eng

What is interface testing, Testing conducted to evaluate whether systems or...

Testing conducted to evaluate whether systems or components pass data and control correctly to one another. Contrast with testing, unit; testing, system. Normal 0

Define brooks law, Define Brooks law. Software was delivered late, was ...

Define Brooks law. Software was delivered late, was not reliable, cost various times the original estimates and often exhibited poor performance characteristics.

What is a modular system, What is a modular system? A modular system h...

What is a modular system? A modular system having of well defined manageable units to well defined  interfaces between them.

Describe the prototyping methods in software process, Describe the prototyp...

Describe the prototyping methods in software process. Two methods i. Evolutionary prototyping - In this approach of system development, the early prototype is prepared and i

What is brainstorming, A group process for generating original and diverse ...

A group process for generating original and diverse ideas.

Describe the various elements of data design, Describe the various elements...

Describe the various elements of data design? i. Data object - The data objects are identified and relationships among various data objects are represented using ERD or data di

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