Description: FREE SHIPPING UK WIDE Refactoring SQL Applications by Pascal L?hermite, Stephane Faroult Provides a set of options for making code modifications to improve the way your database applications function. This work helps you to learn to recognize and assess code that needs refactoring, and to understand the crucial link between refactoring and performance. FORMAT Paperback LANGUAGE English CONDITION Brand New Publisher Description What can you do when database performance doesnt 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, youll find quick fixes for simple problems, in-depth answers for more complex situations, and complete solutions for applications with extensive problems.In this work, 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; and, 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. Author Biography Stephane Faroult first discovered the relational model and the SQL language in 1983, and has been performing database consultancy since then. The founder of RoughSea Ltd, he formerly worked for Oracle.Pascal LHermite has been working with relational databases in OLTP, production and development environments on Oracle Databases for the past 12 years and on Microsoft SQL Server for the past 5 years. Table of Contents Preface; Why Refactor?; Refactoring Database Accesses; How This Book Is Organized; Audience; Assumptions This Book Makes; Conventions Used in This Book; Using Code Examples; Comments and Questions; Safari Long Description What can you do when database performance doesnt 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, youll 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 modificationsRefactoring 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. Details ISBN0596514972 Short Title REFACTORING SQL APPLICATIONS Pages 277 Publisher OReilly Media Language English ISBN-10 0596514972 ISBN-13 9780596514976 Media Book Format Paperback Year 2008 Country of Publication United States Series Oreilly Place of Publication Sebastopol DOI 10.1604/9780596514976 AU Release Date 2008-09-16 NZ Release Date 2008-09-16 UK Release Date 2008-09-16 Imprint OReilly Media Author Stephane Faroult DEWEY 005.75 Illustrations Illustrations Publication Date 2008-09-30 US Release Date 2008-09-30 We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! 30 DAY RETURN POLICY No questions asked, 30 day returns! FREE DELIVERY No matter where you are in the UK, delivery is free. SECURE PAYMENT Peace of mind by paying through PayPal and eBay Buyer Protection TheNile_Item_ID:161841140;
Price: 42.99 GBP
Location: London
End Time: 2024-11-03T13:19:16.000Z
Shipping Cost: 3.67 GBP
Product Images
Item Specifics
Return postage will be paid by: Buyer
Returns Accepted: Returns Accepted
After receiving the item, your buyer should cancel the purchase within: 30 days
Return policy details:
Format: Paperback
Language: English
ISBN-13: 9780596514976
Author: Pascal L?hermite, Stephane Faroult
Type: NA
Book Title: Refactoring SQL Applications
Publication Name: NA
