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 is a technical analyst, What is A Technical Analyst? Ans) Technical...

What is A Technical Analyst? Ans) Technical Analysts perform test assessments and validate system/functional test needs. Depending on the project, single person might wear more

Explain rad model, RAD Model Rapid Application Development Model is ...

RAD Model Rapid Application Development Model is the method of incremental model. Achieves the high speed development using component based construction. Phases

Calculate the peak manning and average rate of software, Q. A software proj...

Q. A software project is planned to cost 95PY in a period of 1 year and 9 months. Calculate the peak manning and average rate of software them build up. Ans. Software project

Show the advantages of incremental model, Q. Show the Advantages of increme...

Q. Show the Advantages of incremental Model? As product is to be conveying in parts total cost of the project is distributed. Limited number of persons is able to be pu

What are the drawbacks of rad model, Question 1 . What are the drawbacks of...

Question 1 . What are the drawbacks of RAD Model Question 2 . Explain why reliability is more important than efficiency? Question 3 . What are the activities of funct

Explain equivalence class partitioning, Q. Explain Equivalence Class Partit...

Q. Explain Equivalence Class Partitioning ? Equivalence Class Partitioning : It is a method in black box testing. It is designed to reduce the number of test cases by dividing

What is exception, What is Exception? Ans) An event that causes suspensi...

What is Exception? Ans) An event that causes suspension of normal program implementation. Types contain addressing exception, operation exception, data exception, overflow excep

Explain throw-away prototyping, Throw-away prototyping Objective: ...

Throw-away prototyping Objective: The principal objective of this model is to validate or to derive the system requirements. It is developed to reduce requir

Illustrate the relationship between time and cost, Q. Illustrate the relati...

Q. Illustrate the relationship between Time and cost? In software projects, time cannot be freely exchanged against cost. Such a trade off is limited by the nature of the softw

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