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

What is incremental analysis, Incremental analysis happens when (partial) a...

Incremental analysis happens when (partial) analysis may be performed on an incomplete product to permit early feedback on the development of that product.

Explain the phased waterfall model, Explain the Phased Waterfall Model ...

Explain the Phased Waterfall Model It is a type of waterfall model where the project is separated into small phases and delivered at intervals by dissimilar teams. Different Te

Define about the requirement traceability matrix, When is RTM (Requirement ...

When is RTM (Requirement traceability matrix) prepared - after or before test case designing? - RTM is prepared before test case designing. - Requirements must be traceable

How the restructuring helps in maintaining a program, The restructuring hel...

The restructuring helps in maintaining a program in the following ways:        (a) Programs have higher quality, good documentation, less complexity, and conformance to modern

State entity and relationship diagram, State Entity /Relationship diagram. ...

State Entity /Relationship diagram. ERD depicts relationships among data objects. The ERD is the notation that is used to conduct the data modeling activity. The primary

Write the process classification, Write the Process classification. In...

Write the Process classification. Informal No detailed process model. Development team chose their own way of working. Managed Explained process model wh

What are the aims of testing, What are the aims of testing? i. T...

What are the aims of testing? i. Testing is a process of executing a program with the target of finding an error. ii. A good test case is one that has high possibilit

Mention some of the design principles, Mention some of the Design principle...

Mention some of the Design principles. The design process should not vary from tunnel vision. The design should not reinvent the wheel. The Design should exhibit unifo

What are the various testing activities, What are the various testing activ...

What are the various testing activities? i. Test planning ii. Test execution iii. Test case design iv. Data collection v. Effective evaluation

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