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

Software configuration management , Software configuration management is a...

Software configuration management is an umbrella activity which is applied by the software procedure. SCM identifies controls, audits and reports modifications that invariably occ

Explain lines of code - software metrics, Q. Explain Lines of code - Softwa...

Q. Explain Lines of code - Software Metrics? Lines of code (LOC) is a software metric used to measure the size of a software program by counting the number of lines in the te

What are the common activities in design process, What are the common activ...

What are the common activities in design process? i. System structuring - The system is subdivided into principle subsystems components and communications among these subsystem

Explain the various phases of SDLC, Explain the Various phases of SDLC ...

Explain the Various phases of SDLC Various phases of SDLC are defined as below: Requirements Analysis Design Coding Software Testing Maintenance.

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

What is parallel/audit testing, Parallel/audit testing is testing where the...

Parallel/audit testing is testing where the user reconciles the output of the latest system to the output of the present system to determine the new system performs the operations

Test questions, Dear Sir/ Madam I have some remaining test questions need ...

Dear Sir/ Madam I have some remaining test questions need to be answered, from yesterday''s test bank can I get a solution please? Regards John

State the term software is engineered, Justify the term "Software is engine...

Justify the term "Software is engineered" Software is engineered not manufactured. Although some similarities exist between software development and hardware manufacture, the t

Why we need restructuring techniques, Q. Why we need restructuring techniqu...

Q. Why we need restructuring techniques? The restructuring helps in maintaining a program in the following ways: (a) Programs have higher excellence better documentation l

What is a modular system, What is a modular system? A modular system h...

What is a modular system? A modular system having of well defined manageable units to well defined  interfaces between them.

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