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

Define archives as records and explain their importance, QUESTION 1 (a)...

QUESTION 1 (a) Define "archives" as records and explain their importance. (b) Elaborate on the steps archivists have to undertake for the storage of archival records. QU

Explain in detail about data modelling, Explain in detail about data modell...

Explain in detail about data modelling. Data modeling makes use of the ERD. Having of 3 interrelated information. The data object. Attributes.  Relationsh

Determine ways to handle concurrency, How to handle concurrency:  Mech...

How to handle concurrency:  Mechanisms Locks Semaphores Monitors Synchronized methods Methods Deadlock avoidance Verification Sim

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.

Two software characteristics, Discuss any two software characteristics. ...

Discuss any two software characteristics. Software is not manufactured : The life of software is from method exploration to the retirement of the software product. It is one t

What are the testing principles of software testing, What are the testing p...

What are the testing principles the software engineer must apply whereas performing the software testing? i. All tests should be traceable to customer requirements. ii. Test

Define the optimising level of maturity model, Level 5 (Optimising) O...

Level 5 (Optimising) Organisation satisfies all the requirements of level-4. This is final level. Organisation at this maturity level is considered almost perfect. At this st

What does data modelling means, What does data modelling means? Data mo...

What does data modelling means? Data modelling is the first step in the analysis modelling. In data modelling the data objects are checked independently of processing. The data

How is the state diagram helpful to an engineer, Problem: a) Assume a w...

Problem: a) Assume a washing machine. List all possible states of the washing machine. Draw a state diagram showing also the events triggering the change of states where poss

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