Refactoring SQL Applications

Refactoring SQL Applications
Author :
Publisher : "O'Reilly Media, Inc."
Total Pages : 300
Release :
ISBN-10 : 9780596551773
ISBN-13 : 0596551770
Rating : 4/5 (770 Downloads)

Book Synopsis Refactoring SQL Applications by : Stephane Faroult

Download or read book Refactoring SQL Applications written by Stephane Faroult and published by "O'Reilly Media, Inc.". This book was released on 2008-08-22 with total page 300 pages. Available in PDF, EPUB and Kindle. Book excerpt: What can you do when database performance doesn't meet expectations? Before you turn to expensive hardware upgrades to solve the problem, reach for this book. Refactoring SQL Applications provides a set of tested options for making code modifications to dramatically improve the way your database applications function. Backed by real-world examples, you'll find quick fixes for simple problems, in-depth answers for more complex situations, and complete solutions for applications with extensive problems. Learn to: Determine if and where you can expect performance gains Apply quick fixes, such as limiting calls to the database in stored functions and procedures Refactor tasks, such as replacing application code by a stored procedure, or replacing iterative, procedural statements with sweeping SQL statements Refactor flow by increasing parallelism and switching business-inducted processing from synchronous to asynchronous Refactor design using schema extensions, regular views, materialized views, partitioning, and more Compare before and after versions of a program to ensure you get the same results once you make modifications Refactoring SQL Applications teaches you to recognize and assess code that needs refactoring, and to understand the crucial link between refactoring and performance. If and when your application bogs down, this book will help you get it back up to speed.


Refactoring SQL Applications Related Books

Refactoring SQL Applications
Language: en
Pages: 300
Authors: Stephane Faroult
Categories: Computers
Type: BOOK - Published: 2008-08-22 - Publisher: "O'Reilly Media, Inc."

GET EBOOK

What can you do when database performance doesn't meet expectations? Before you turn to expensive hardware upgrades to solve the problem, reach for this book. R
Refactoring Databases
Language: en
Pages: 553
Authors: Scott W. Ambler
Categories: Computers
Type: BOOK - Published: 2006-03-03 - Publisher: Pearson Education

GET EBOOK

Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility
Refactoring Legacy T-SQL for Improved Performance
Language: en
Pages: 236
Authors: Lisa Bohm
Categories: Computers
Type: BOOK - Published: 2020-01-14 - Publisher: Apress

GET EBOOK

Breathe new life into older applications by refactoring T-SQL queries and code using modern techniques. This book shows you how to significantly improve the per
Refactoring Legacy T-SQL for Improved Performance
Language: en
Pages: 245
Authors: Lisa Böhm
Categories: SQL (Computer program language)
Type: BOOK - Published: 2020 - Publisher:

GET EBOOK

Breathe new life into older applications by refactoring T-SQL queries and code using modern techniques. This book shows you how to significantly improve the per
Refactoring
Language: en
Pages: 461
Authors: Martin Fowler
Categories: Computers
Type: BOOK - Published: 1999 - Publisher: Addison-Wesley Professional

GET EBOOK

Refactoring is gaining momentum amongst the object oriented programming community. It can transform the internal dynamics of applications and has the capacity t