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

How can we re-engineering of any product, How can we re-engineering of any ...

How can we re-engineering of any product One additional difficulty in adopting this approach is large investment which exists in software system maintenance. It requires additi

Explain about function count - software metrics, Q. Explain about Function ...

Q. Explain about Function count? Function count:- It measures the functionality from the user point of view that is on the basis of what the user requests and receives in ret

Jk flip-flop, It should include all the theory that you need to complete th...

It should include all the theory that you need to complete the requested design, and all the simulation documents that you produce after synthesizing the circuit. Briefly, your rep

State both verification and validation, Define Verification &Validation. ...

Define Verification &Validation. Verification : The set of actions that make sure software correctly implements a particular function. Validation : The set of actions that

Software project planning necessitate what activities, Q. Software project ...

Q. Software project planning necessitate what activities? What are the difficulties encountered in measuring the Software Costs? Ans. Software project planning necessitate th

Write short note on black box testing, Write short note on black box testin...

Write short note on black box testing. The black box testing is also known as behavioural testing. This method fully focuses on the functional requirements of the software. Te

Explain what is the resource discovery problem, Question: (a) Explain ...

Question: (a) Explain what is the resource discovery problem? (b) Distinguish between centralized (hybrid) and decentralized (pure) peer to peer network? (c) Give an e

Define object and class associations, Q. Define Object and class associatio...

Q. Define Object and class associations? Object/class associations:- Objects/classes interact with each other. Multiplicity defines how many instances of one object/class can

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