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

Explain the essential api concepts associated with j2me, Question: (a) ...

Question: (a) State and explain the essential API concepts associated with J2ME. (b) Connected Limited Device Configuration provides two types of application security; stat

Software modelling, Enterprise software platforms are designed to simpl...

Enterprise software platforms are designed to simplify complex enterprise problems for the development, deployment, and maintenance of multi-tier enterprise solutions. In

Demonstrate about analysis and design of a software system, Aim The aim...

Aim The aim of this Assignment is to demonstrate knowledge about the analysis and design of a  software  system  and  understanding  of  the  application  of  an  object-orient

What is evolutionary prototype, Evolutionary Prototype In this, prot...

Evolutionary Prototype In this, prototype is constructed to learn about software problems and their solutions in successive steps. Prototype is initially developed to satisf

Explain system testing, The process of testing an integrated hardware and s...

The process of testing an integrated hardware and software system to determine that the system meets its described requirements. Such testing might be conducted in both the develop

Explain the meaning of throw away prototyping, What is meant by Throw away ...

What is meant by Throw away Prototyping? Giving the user a system which is incomplete and then augmenting and modifying it so that user requirements become clear. The obj

What are the task involved in design process of sdlc, What are the task inv...

What are the task involved in design process of SDLC General tasks involved in the design process are the following: i)  Design various blocks for overall system processes.

Define maintenance, Define maintenance. Maintenance is explained as the...

Define maintenance. Maintenance is explained as the process in which changes are executed by either modifying the existing system's architecture or by adding latest components

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