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

Differentiate between smoke testing and sanity testing, Differentiate betwe...

Differentiate between smoke testing and sanity testing. -Smoke testing verifies all areas of application; sanity testing recognizes one or few areas only. -Smoke testing is

What is data validity, Data validity is the reasonableness and correctness ...

Data validity is the reasonableness and correctness of data.

Explain lines of code - software metrics, Q. Explain Lines of code - Softwa...

Q. Explain Lines of code - Software Metrics? Lines of code (LOC) is a software metric used to measure the size of a software program by counting the number of lines in the te

What are the tools of environmental model, What are the Tools of environme...

What are the Tools of environmental  model (i)  Statement of purpose: It indicates basic objectives of system. (ii)  Event list: It describes different events of system

Explain in detail about structural modeling, Explain in detail about Struct...

Explain in detail about Structural Modeling. Structural model having a detail refinement of ERD, data flow model and control flow model. Creating an ERD. Example: Saf

Define data dictionary, Define Data Dictionary. The data dictionary is ...

Define Data Dictionary. The data dictionary is defined as an organized collection of all the data elements of the system with accurate and rigorous definitions so that user and

Software Quality Assurance - Defect Amplification and Remova, Errors from p...

Errors from previous stage Errors passed through Amplified errors Newly generated errors Errors passed to next stage Testing phase of project-A 35 35 0 5 20 Testing phase of Projec

What is change management tools, What is Change management tools? Chang...

What is Change management tools? Change management is a process in which it can be modelled and integrated with a version management system. Change management tools Fo

Explain integration testing, 1. An orderly development of testing in which ...

1. An orderly development of testing in which software elements, hardware elements, or both are joined and tested, to check out their interactions, unless the entire system has bee

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