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

Explain in detail about black box testing, Explain in detail about Black bo...

Explain in detail about Black box testing. Black box or behavioural testing focuses on the functional needs of the software. It is applied during the last stage of testing.

State about the data dictionary, State about the Data Dictionary  This...

State about the Data Dictionary  This is another tool of requirement analysis that reduces complexity of DFD. A data dictionary is a catalog of all components of a system. DFD

What is system engineering, What is System Engineering? System Engineer...

What is System Engineering? System Engineering means designing, executing, deploying and operating systems which contain hardware, software and people.

What do you mean by software engineering, Q. What do you mean by Software E...

Q. What do you mean by Software Engineering? What is the use of Software Engineering? Ans) Software engineering is engineering for software development. A simple program can be

How is cyclomatic complexity useful in program test, Q. How is cyclomatic c...

Q. How is cyclomatic complexity useful in program test and What is sequence of testing and  What is testability? Ans. Cyclomatic complexity measures the amount of decision lo

Distinguish among verification and validation, Distinguish between verifica...

Distinguish between verification and validation. Verification is the set of activities that ensure that software properly implements a specific function. Validation is a differ

What is data binding, What is Data Binding?    The matrix that attempts...

What is Data Binding?    The matrix that attempts to capture the module-level concept of coupling is data binding. Data binding are a calculate that captures the data interacti

Elicitation, explain the goal oriented requirement elicitation process with...

explain the goal oriented requirement elicitation process with a neat sketch

Defining a prototype on the overall cost, Describe the effect of defining a...

Describe the effect of defining a prototype on the overall cost of the software project? The prototyping model: In this model, a prototype (an previous approximation of a fin

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