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 software measurement, Define software measurement. A software me...

Define software measurement. A software measurement is a method or method that applies software calculates to a class of software engineering objects to attain a predefined goa

What are the parameters of performance testing, The term "performance testi...

The term "performance testing" is usually used synonymously with stress testing, load testing, reliability testing, and volume testing. It is a part of system testing, but it's als

Hardware requirements - inmagic plus software package, Hardware Requirement...

Hardware Requirements: INMAGIC Plus software package requires the following computer configuration:  i)  Micro : IBM PC or compatible with a minimum 640 K RAM.  ii)  Ope

Legacy Challenge, What is the Legacy Challenge in Software Engineering?

What is the Legacy Challenge in Software Engineering?

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

Mention some of the Design principles. a.    The design process should not suffer from tunnel vision. b.    The design should not reinvent the wheel. c.     The Design sh

What is unit testing explain, Q. What is Unit testing explain ? Unit t...

Q. What is Unit testing explain ? Unit testing: Unit testing is undertaken after a module has been coded and successfully reviewed. Unit testing (or module testing) is the te

What is clear box testing, Clear box testing is the similar as white box te...

Clear box testing is the similar as white box testing. It is a testing approach that consider the application's program structure, and acquires test cases from the application's pr

Difference between module coupling and module collection, What is the diffe...

What is the difference between module coupling and module collection? Cohesion is the property of a one module and can be defined as glue that keeps the data elements within a

Infomation systems, How can a company improve quality of business informati...

How can a company improve quality of business information?

State the defined level of maturity model, Level 3 (Defined) The org...

Level 3 (Defined) The organisation satisfies all the requirements of level-2. Atthis maturity level, the softwaredevelopmentprocesses arewell defined, managed and documented

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