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 object in software engineering, Q. Define Object in Software Enginee...

Q. Define Object in Software Engineering? Object:- An object is something which is capable of being seen, touched or sensed. Each object has certain distinctions or attributes

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

Define Data Dictionary. The data dictionary can be explained as an organized collection of all the data elements of the system with precise and rigorous explanations so that us

Define debugging, Define debugging. Debugging is defined as the process...

Define debugging. Debugging is defined as the process of removal of defect. It occurs as a consequence of successful testing.

What are the misunderstanding arises in software development, What are the ...

What are the misunderstanding arise in software development Some of the common misunderstandings regarding software development are given below. 1.  Correcting errors is eas

What are the objectives of software design, What are the objectives of soft...

What are the objectives of software design? Objectives of software design                         The objective of the design phase is to plan a solution of the difficulty

What are the challenges in software, What are the challenges in software?  ...

What are the challenges in software?  Copying with legacy systems. Heterogeneity challenge  Delivery times challenge

What is criticality, What is Criticality? The degree of impact that a ne...

What is Criticality? The degree of impact that a necessity, module, error, fault, failure, or other item has on the operation of a system or development.

CRT, EXPLAIN THE WORKING OF CRT?

EXPLAIN THE WORKING OF CRT?

Software engineering, Software Engineering A  high technology system e...

Software Engineering A  high technology system encompasses a  number of  elements like   people, hardware, software, database, documentation, and process.  System engineering

What is a utility, "Utility" is a software tool designed to perform some re...

"Utility" is a software tool designed to perform some regularly used support function. For example, single utility is a program to print files.

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