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

Briefly explain integration testing, Q. Briefly explain Integration Testing...

Q. Briefly explain Integration Testing? Integration Testing: In this the module are methodically integrated and tested to find protocol design error, interface problems, errors

Software engineer, Differance b/w Liner sequenrial modal with incremental m...

Differance b/w Liner sequenrial modal with incremental modal

Develop a clinic system - unified modeling language, You are to develop a C...

You are to develop a Clinic System . 1. Identify and briefly explain the objects, classes, methods and attributes for the Clinic System. 2. Draw a use case diagram to represe

Illustrate about the software process technology, Illustrate about the  SO...

Illustrate about the  SOFTWARE PROCESS TECHNOLOGY   Software industry considers software development like a process. According to Rumbaugh and Booch, "A process defines who is

Define the optimising level of maturity model, Level 5 (Optimising) O...

Level 5 (Optimising) Organisation satisfies all the requirements of level-4. This is final level. Organisation at this maturity level is considered almost perfect. At this st

Explain in detail about data modeling, Explain in detail about data modelin...

Explain in detail about data modeling Data modeling creates use of the ERD. Having of 3 interrelated information. The data object. Relationships. Attributes

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

Write definition of state transition diagram, Write definition of state tra...

Write definition of state transition diagram? State transition diagram is mainly a collection of states and events. Due to the events the system has to change its state. It als

Stats free, system architecture block diagram

system architecture block diagram

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