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

C++, program for full subtractor?

program for full subtractor?

What is software verification, What is software verification? Ans) In ge...

What is software verification? Ans) In general the demonstration of consistency, completeness, and correctness of the software at every stage and between every stage of the deve

How many types of traceability in software engineering, How many types of t...

How many types of traceability in software engineering? i. Source traceability - These are generally the links between requirement to stakeholders who suggests these requiremen

Find the decrement of failure intensity per failure, Q. Assume that a progr...

Q. Assume that a program will experience 200 failures in infinite time. It has now experienced 100. The initial failure intensity was 20 failures/CPU hr. (i) Determine the cur

What are the common approaches in debugging, What are the common approaches...

What are the common approaches in debugging? Brute force method: The memory dumps and run-time tracks are examined and program with write statements is loaded to obtain clues t

Case study : online bookshop system, A major book retailer is planning to d...

A major book retailer is planning to develop a computer system to handle their new online bookshop: BooksUniverse.com. You have been chosen to do the analysis and design using Obje

What is branch coverage, What is Branch coverage? Ans) Test coverage cri...

What is Branch coverage? Ans) Test coverage criteria which needs that for each decision point each possible branch be implemented at least once. Syn: decision coverage. Contrast

How to compute the cyclomatic complexity, How to compute the cyclomatic com...

How to compute the cyclomatic complexity? The cyclomatic complexity can be calculated by any one of the following ways. 1. The numbers of regions of the flow graph correspon

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