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

ER Diagram, ER Diagram for Safe Home System

ER Diagram for Safe Home Systems

What is Regression testing, Regression testing:- It is the re-execution ...

Regression testing:- It is the re-execution of some subset of tests that have already been conducted to make sure the changes that have not been propagated unintended side e

Define repeated inheritance, Repeated inheritance If a class inherits ...

Repeated inheritance If a class inherits more than once from the same class then it is referred to as repeated inheritance.

Explain hybrid design, Hybrid design: Pure top-down or pure bottom up appr...

Hybrid design: Pure top-down or pure bottom up approaches are often not practical thus hybrid approach which combines  the above two approaches is often used.

Explain dynamic testing, Verification or validation performed which impleme...

Verification or validation performed which implements the system's code.

Explain in detail about software maintenance, Explain in detail about softw...

Explain in detail about software Maintenance. Software maintenance is an action in which program is modified after it has been put into use. Maintenance is termed as the

Hardware and software requirements - cds - isis software, Hardware and Soft...

Hardware and Software Requirements: The present versions of CDS/ISIS require the following minimum hardware and software:  i)  MS-DOS Version: an IBM PC or Compatible micro

Draw an appropriate use-case model, This case-study describes the requireme...

This case-study describes the requirements of an airline travel agency who want to develop a website to allow customers to make online bookings. The outline requirements are descri

Local data object defined in a subroutine, It is possible to assign a local...

It is possible to assign a local data object defined in a subroutine or function module to a field group. False.

What is ripple effect, Q. What is ripple effect? How does it affect the sta...

Q. What is ripple effect? How does it affect the stability of a program? Ans. The ripple effect is a term used to explain a situation where like the ever expanding ripples

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