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

Prolog, package(''python'', ''2.6.5''). package(''python'', ''2.5.4''). pac...

package(''python'', ''2.6.5''). package(''python'', ''2.5.4''). package(''python'', ''1.5.2''). package(''python'', ''3.1.0''). and I already have these functions that provide me:

Explain operational testing, Describe Operational Testing? Ans) Testing ...

Describe Operational Testing? Ans) Testing done by the end user on software in its normal operating environment.

What are the objectives of analysis modelling, What are the objectives of A...

What are the objectives of Analysis modelling? i. To explain what the customer requires. ii. To establish a basis for the creation of software design. iii. To devise a se

Question, why are older data models are being replaced by new data models

why are older data models are being replaced by new data models

What is cardinality in data modelling, What is cardinality in data modellin...

What is cardinality in data modelling? Cardinality in data modeling, cardinality verifies how the number of occurrences of one object is related to the number of occurrences of

Give the procedure of the delphi method, Give the procedure of the Delphi m...

Give the procedure of the Delphi method. 1. The co-ordinator presents a specification and estimation form to all experts. 2. Co-ordinator calls a group meeting where the exp

Software restructuring, Software restructuring Software restructuring c...

Software restructuring Software restructuring changes source code and / or data an effort to make it amenable to future changes. In general, restructuring does not change the o

Discuss about the software maintenance, Discuss about the Software Maintena...

Discuss about the Software Maintenance Maintenance in the normal sense means correcting problems caused by wear and tear though software maintenance is different.  Software is

Incomplete wrong Lisp code with error, Check mail from for assignment. ...

Check mail from for assignment. Are you kidding with me. What kind of code you sent. Did you even execute before sending. It has error. Either do it as per the assignment or

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