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

Define cohesion & coupling, Define cohesion & coupling? Give suitable examp...

Define cohesion & coupling? Give suitable examples.  Coupling : Coupling refers to the strength of the relationship among modules in a system. Coupling shows how strongly dif

What is version description document, Explain version description document ...

Explain version description document (VDD)? Ans) Version description document (VDD) is a document that accompanies and signifies a given version of a software product. Typically

Define software scope, Define software scope. The first software projec...

Define software scope. The first software project management activity is the determination of software scope. Scope is explained answering the following questions. Context:

Briefly describe the principles of the dsdm methodology, Question: a) B...

Question: a) Briefly describe the principles of the DSDM methodology. b) What are the advantages of using the DSDM methodology? c) The MOSCOW technique is used to priori

What is quality, What is quality? Quality, simplistically, means that a...

What is quality? Quality, simplistically, means that a product should meet its requirement. This is problematical for software systems. There is a tension among custom

What is a process modeling and management tool, What is a process modeling ...

What is a process modeling and management tool? Process modeling and management tools are used to show the key elements of a process so it can be better understood. Such tools

Explain the throw away prototype, Explain the Throw away prototype I...

Explain the Throw away prototype In this technique, prototype is discarded once its purpose is fulfilled and final system is built from scratch. Prototype is built quickly t

What does data object means, What does data object means? Data object i...

What does data object means? Data object is a group of attributes that behave as an aspect, quality, characteristic or descriptor of the object.

Class diagram, Explain the compare of class diagram

Explain the compare of class diagram

Explain in brief the concept of functional independence, Explain in brief t...

Explain in brief the concept of Functional independence ?

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