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

SQA Planning, I want to know that what are the activities, roles,artifacts ...

I want to know that what are the activities, roles,artifacts and goals do a planning phase of SQE encempass? How can we prepare sqa plan for any project?

Determine the process of software review, Determine the process of Software...

Determine the process of Software Review - This is an evaluation technique which involves bringing together a group of technical personnel to analyze a software artifact to im

The spiral model of software development, The spiral model of software deve...

The spiral model of software development Contains project risks evaluation during every iteration

Describe continual integration, Question 1 What is SSAD? Explain in detail...

Question 1 What is SSAD? Explain in detail Question 2 Explain any three limitations of the agile process Question 3 Describe continual integration Question

Explain the regression testing, What is regression testing? Regression...

What is regression testing? Regression testing is the re-execution of some subject texts that have previously been conducted to make sure that changes have not propagated unin

Explain the empirical estimation models, Write short notes on empirical est...

Write short notes on empirical estimation models. Estimation model for computer software uses empirically derived formulas to expect effort as a function of line of codes (LOC)

How a prototype can be categorised, How a prototype can be categorised ...

How a prototype can be categorised 1.  A paper prototype which is a model depicting human machine interaction in a form which makes user understand how such interaction, would

Advantages of using mobile agents, Question: (a) Give three advantages...

Question: (a) Give three advantages of using mobile agents. (b) Distinguish between Static Itinerary Static Order (SISO) and Static Itinerary Dynamic Order (SIDO) mobility

Explain the cardinality and optionally, Cardinality & Optionally Card...

Cardinality & Optionally Cardinality represents the relationship between two entities. Consider one to many relationship between two entities -student andclass. Here cardinal

What is the test case, Test Case A test case is a unit level document d...

Test Case A test case is a unit level document describing the inputs, steps of implementation and the expected result of each test condition for each requirement from the BRD.

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