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 the process of software change, What is meant by software change? ...

What is meant by software change? Software change is termed as the change in nature of software as the requirements of software changes.

Write about the types of project plan, Write about the types of project pla...

Write about the types of project plan. Quality plan - This plan explains the quality procedures and standards that will be used in a project. Validation plan - This plan explai

What are the advantages of evolutionary prototyping, What are the advantage...

What are the advantages of evolutionary prototyping? i. Fast delivery of the working system. ii. User is included while developing the system. iii. More useful system can

Explain throw-away prototyping, Throw-away prototyping Objective: ...

Throw-away prototyping Objective: The principal objective of this model is to validate or to derive the system requirements. It is developed to reduce requir

Compare the manpower and development time, Q. Compare the Manpower and deve...

Q. Compare the Manpower and development time? Manpower may perhaps refer to labour Manpower either an abstract term for human labour effort as opposed to machines, animals a

Software engineer, Differance b/w Liner sequenrial modal with incremental m...

Differance b/w Liner sequenrial modal with incremental modal

State lehmans first law, State Lehman's First law. A program that is u...

State Lehman's First law. A program that is used in true world environment essentially must change or become progressively less useful in that environment.

Explain requirement issues in software risks, Q. Draw the flow chart of Ris...

Q. Draw the flow chart of Risk Management-Activity and explain various Software risks. Ans RISK is a problem that could cause a few loss or threatens the success of the proje

Explain in detail about the software process, Explain in detail about the s...

Explain in detail about the software process. It is explained as the structured set of activities that are required to develop the software system. Fundamental activ

Define external coupling, Q. Define External coupling? External coupli...

Q. Define External coupling? External coupling: A form of coupling in that a module has a dependency to other module external to the software being developed or to a particul

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