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

Patient management system for a hospital, Maintain you are involved in a la...

Maintain you are involved in a large project concerning the development of a patient management system for a hospital. You may opt for one of two plans. The first plan is to start

Explain the cardinality and optionally, Cardinality & Optionally Card...

Cardinality & Optionally Cardinality represents the relationship between two entities. Consider one to many relationship between two entities -student andclass. Here cardinal

Explain the process of prototyping, Explain the process of Prototyping ...

Explain the process of Prototyping Prototyping is a process which enables developer to create a small model of software. IEEE 610.12 standard defines prototype as a preliminary

What is operational requirements, What is Operational Requirements? Ans)...

What is Operational Requirements? Ans) Qualitative and quantitative parameters that states the desired operational capabilities of a system and serve as a basis for determining

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

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

Write short note on black box testing, Write short note on black box testin...

Write short note on black box testing. The black box testing is also known as behavioural testing. This method fully focuses on the functional needs of the software. Tests are

What is outputs, What is Outputs? Ans) Products, services, or informatio...

What is Outputs? Ans) Products, services, or information supplied to meet end user requirements.

What are basic key process areas in cmm, Q. What are basic Key process area...

Q. What are basic Key process areas in CMM? Ans) Key Process Areas (KPAs) adds the areas an organization could focus to improve its software process to the next level. Except f

What is function count, Function count:- It measures the functionality fro...

Function count:- It measures the functionality from the user point of view, that is, on the basis of what the user requests and receives in return. Therefore it deals with the fun

Explain ad hoc testing, Ad hoc testing is a testing approach. It is the lea...

Ad hoc testing is a testing approach. It is the least formal testing approach.

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