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

Quality control concept, (i) Concept definition of Quality Control and Qual...

(i) Concept definition of Quality Control and Quality Assurance (ii) Tools used in quality control (iii) Acceptance sampling and process control (iv) Statistical tools for

List any three characteristics of a good srs, List any three characteristic...

List any three characteristics of a good SRS.   The SRS should be: Correct , Unambiguous, Complete    1. Correct: An SRS is correct iff every requirement stated therein is one

What are the different rapid prototyping techniques, What are the different...

What are the different Rapid prototyping techniques? i. Dynamic high level language development. ii. Database programming. iii. Component and application assembly.

Compute the mccobes cyclomatic complexity, Q. Compute the McCobes cyclomati...

Q. Compute the McCobes cyclomatic complexity? (i) compute the McCobe's cyclomatic complexity (ii) Find out independent path Ans (i) Cyclomate complexity V (

Explain function points, Function points: Function point calculates the fu...

Function points: Function point calculates the functionality from the user point of view, that is, on the basis of what the user request and receives in return. Thus, it deals wit

Discuss in brief about iterative waterfall, Discuss iterative waterfall ...

Discuss iterative waterfall Iterative waterfall model a) Requirement collecting  phase in which all requirements are specified. b) The design phase is responsible for cr

Type of organizational behaviour, what is type of organizational behaviour ...

what is type of organizational behaviour like classical,neo and morden?

What are the common approaches in debugging, What are the common approaches...

What are the common approaches in debugging? Brute force method: The memory dumps and run-time tracks are explained and program with write statements is loaded to get clues to

Write short notes on configuration management, Q. Write short notes on Conf...

Q. Write short notes on Configuration Management? Software configuration management is a bunch of tracking and control activities that begin when a software project begins an

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