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

Design and run the usability testing, You have been commissioned to design ...

You have been commissioned to design and run the usability testing for an upcoming e-commerce website that will sell computing hardware and software. In this first part of the

What are the properties of srs, What are the properties of SRS? i. Corr...

What are the properties of SRS? i. Correct - The SRS must be built up to date while  appropriate requirements are identified. ii. Unambiguous - When the requirements are pro

How can you create the new system, How can you create the new system  S...

How can you create the new system  System is to be computerised. Following will be created: (i)                 All DVD and CD data will be stored on a database   (ii)

Software engineering, Software Engineering A  high technology system e...

Software Engineering A  high technology system encompasses a  number of  elements like   people, hardware, software, database, documentation, and process.  System engineering

What are decision tables, What are decision tables? Why do we use them? ...

What are decision tables? Why do we use them? - Decision tables are specification-based techniques that are more focused on business rules or business logic. - A decision ta

What is top-down testing, An integration testing methods that tests the hig...

An integration testing methods that tests the high-level components first using stubs for lower-level known as components that have not yet been integrated and that stimulate the n

When we require to re-engineer, When to Re-Engineer? When the syst...

When to Re-Engineer? When the system alter are mostly confined to part of the system then re-engineer that part. When hardware or software support becomes obsolete.

Determine the problems of software maintenance, Determine the problems of s...

Determine the problems of software maintenance Software maintenance has the below problems: i)  It is very cumbersome to analyse and understand code written by somebody.

What are basic key process areas in cmm, Q. What are basic Key process area...

Q. What are basic Key process areas in CMM? Ans) Key Process Areas (KPAs) adds the areas an organization could focus to improve its software process to the next level. Except f

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