Actions for Refactoring SQL applications

Email RIS file
Bookmark
Report an Issue

Refactoring SQL applications / Stephane Faroult with Pascal L'Hermite

Author
Faroult, Stéphane
Published
Sebastopol, Calif. : O'Reilly Media, 2008.
Edition
1st ed.
Physical Description
1 online resource (xv, 277 pages) : illustrations
Additional Creators
L'Hermite, Pascal
Access Online

Availability

I Want It
I Want It

Finding items...

Contents
1. Assessment -- A Simple Example -- Assessing Possible Gains -- 2. Sanity Checks -- Statistics and Data Skewness -- Indexing Review -- Parsing and Bind Variables -- Bulk Operations -- Transaction Management -- 3. User Functions and Views -- User-Defined Functions -- Views -- 4. Testing Framework -- Generating Test Data -- Comparing Alternative Versions -- 5. Statement Refactoring -- Execution Plans and Optimizer Directives -- Analyzing a Slow Query -- Refactoring the Query Core -- Rebuilding the Initial Query -- 6. Task Refactoring -- The SQL Mindset -- Restructuring the Code -- 7. Refactoring Flows and Databases -- Reorganizing Processing -- Shaking Foundations -- 8. How It Works: Refactoring in Practice -- Can you Look at the Database? -- Queries of Death -- All These Fast Queries -- No Obvious Very Wrong Query -- Time to Conclude -- A. Scripts and Sample Programs -- B. Tools.
Summary
What can you do when database performance doesn't meet expectations? This book offers methods for refactoring (or changing) SQL code to improve performance without altering a database application's purpose -- and helps you do it on a shoestring budget. This isn't a rehash of theory, but a tested set of options for making code modifications to dramatically improve the way your applications function.
Subject(s)
Other Subject(s)
ISBN
9780596514976
0596514972
9780596551773 (electronic bk.)
0596551770 (electronic bk.)
9780596154950 (electronic bk.)
059615495X (electronic bk.)
Digital File Characteristics
text file
Copyright Note
Copyright © O'Reilly Media, Inc. 2008
View MARC record | catkey: 37415904