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 software quality assurance, Software Quality Assurance and Soft...

Software Quality Assurance and Software Quality Control SQA verifies if the process that is followed to form a product is effective and does not have process defects while SQC

What is dynamic analysis, The process of evaluating a program based on impl...

The process of evaluating a program based on implementation of that program. Dynamic analysis approaches rely on implementing a piece of software with selected test data.

What are the benefits of modular design, What are the benefits of modular d...

What are the benefits of modular design? Changes made during testing and maintenance becomes manageable and they do not affect other modules.

Describe any types of feasibility study, System Development Life Cycle (SDL...

System Development Life Cycle (SDLC) stages are sometimes known as System Study. System concepts which are important in developing business information systems expedite problem sol

What are the misunderstanding arises in software development, What are the ...

What are the misunderstanding arise in software development Some of the common misunderstandings regarding software development are given below. 1.  Correcting errors is eas

Explain the difference between latent and masked defect, Explain the differ...

Explain the difference between Latent and Masked Defect. Latent Defect is one which has been in the system for a long time; but is discovered now. I.e. A defect which has been

Why is maintenance of a software important, Q. Why is maintenance of a soft...

Q. Why is maintenance of a software important? Discuss some of the problems that are faced during maintenance of software. Ans: The modification of a software product subsequ

Explain diffrent types of system testing, Q. Explain diffrent types of syst...

Q. Explain diffrent types of system testing? System testing System tests are designed to validate a fully developed system to assure that it meets its requirements. There are f

Determine the levels of capability maturity model, Determine the levels of ...

Determine the levels of Capability Maturity Model(CMM). Capability Maturity Model(CMM) Level 1:Initial - Few processes are explained  and individual efforts are taken. Le

How will you convince the ceo that crm will make improvement, Marketing and...

Marketing and Sales (M/S) is the focal point of many of Hawkins Cookers Ltd, because they are responsible for selling the company's product (a) Consider you are the Chief Inform

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