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 SQL Applications
Language: en
Pages: 296
Authors: Stéphane Faroult
Categories: Computers
Type: BOOK - Published: 2008 - Publisher: "O'Reilly Media, Inc."

GET EBOOK

This practical work explains how to improve database performance dramatically and inexpensively with surgical changes to the code.
Refactoring Databases
Language: en
Pages: 386
Authors: Ambler
Categories:
Type: BOOK - Published: 2006 - Publisher:

GET EBOOK

Modernizing Legacy Applications in PHP
Language: en
Pages: 286
Authors: Paul M. Jones
Categories: Computers
Type: BOOK - Published: 2016-08-31 - Publisher: Packt Publishing Ltd

GET EBOOK

Get your code under control in a series of small, specific steps About This Book Learn to extract and replace legacy artifacts, Improve your application from th
Working Effectively with Legacy Code
Language: en
Pages: 457
Authors: Michael Feathers
Categories: Computers
Type: BOOK - Published: 2004-09-22 - Publisher: Prentice Hall Professional

GET EBOOK

Get more out of your legacy systems: more performance, functionality, reliability, and manageability Is your code easy to change? Can you get nearly instantaneo