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 are the phases of problem solving loop, What are the phases of Problem...

What are the phases of Problem solving Loop? Problem definition identifies the problem to be resolved. Technical development helps to resolve the Problem through various Te

What is common coupling, Q. What is Common coupling? Common coupling: ...

Q. What is Common coupling? Common coupling: With general coupling module A and module B have shared data. Global data areas are usually found in programming languages. Formu

What is software bug, Explain Software Bug? Ans) A fault in a program wh...

Explain Software Bug? Ans) A fault in a program which origins the program to perform in an unintended or unanticipated manner.

What is dynamic analysis, The process of evaluating a program based on impl...

The process of evaluating a program based on implementation of that program. Dynamic analysis approaches rely on implementing a piece of software with selected test data.

Goals of quality control, Describe how the goals of quality control (QC) fl...

Describe how the goals of quality control (QC) flexible manufacturing systems (FMS), design for assembly (DFA)and low overall costs can be best combined by computer integrated manu

What is user documentation, "User documentation" is a document that explain...

"User documentation" is a document that explains the way a software product or system should be used to get the desired results.

Application design - micro cds-isis software, Application Design: Micr...

Application Design: Micro CDS/ISIS is a text oriented software package. It is a good , ho ice if one wishes to store textual data, retrieve the data by certain criteria, and d

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

What is software configuration management, What is Software configuration m...

What is Software configuration management? ans)Software Configuration Management (SCM) is the control and the recording of alter that are made to the software and documentation

Distinguish between verification and validation, Distinguish between verifi...

Distinguish between verification and validation. Verification refers to the set of activities that make sure that software correctly executes a specific function. Validation re

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