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

Explain working of code inspectors, Q. Explain working of Code inspectors? ...

Q. Explain working of Code inspectors? Code inspectors A code inspector does a simple job of enforcing standards in a uniform way for many programs. These are able to be sing

What is a vertical microinstruction, What is a vertical microinstruction? ...

What is a vertical microinstruction? Ans) A vertical microinstruction is a microinstruction that states one of a sequence of operations required to carry out a machine language

What is error seeding, Define Error seeding? Ans) The process of intenti...

Define Error seeding? Ans) The process of intentionally adding called as faults to those already in a computer program for the purpose of monitoring the rate of recognition and

What is top-down strategy, What is Top-Down Strategy? Ans) Top down inte...

What is Top-Down Strategy? Ans) Top down integration is basically an approach where modules are produced and tested starting at the top level of the programming hierarchy and re

Recreating Sections of Google+ in C, Create a compound data type called Pos...

Create a compound data type called Post to store messages posted on Google+. Post should include: Name / Data Type / Description date / char [9] / date fields for

Explain the concept of decision tables, Explain the concept of Decision Tab...

Explain the concept of Decision Tables Decision table models complex logic into precise yet compact way. A decision table lists causes and effects in a matrix. Every column

What is software re-engineering, What is software re-engineering? No fu...

What is software re-engineering? No functionality is added to the system. Rather than, the system is modified to compose it easier to understand and change. System re-engineeri

Why waterfall model is advantageous than adhoc methods, Q. Why Waterfall mo...

Q. Why Waterfall model is advantageous than Adhoc Methods? Why Waterfall model is advantageous than Adhoc Methods AC16 Software Engineering Ad-hoc Process Models -Process

Unix, A friend has promised to log in at a particular time. However, he nee...

A friend has promised to log in at a particular time. However, he needs to be contacted as soon as he logs in. The shell script checks after every minute whether he has logged in o

Advantage of software life cycle model, Q. Advantage of software life cycle...

Q. Advantage of software life cycle model? The advantage of this model is the wide range of options to accommodate the good features of outer life cycle models. It becomes equi

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