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: 554
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
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
Modernizing Legacy Applications in PHP
Language: en
Pages: 249
Authors: Paul Jones
Categories: Computers
Type: BOOK - Published: 2014-05-02 - Publisher: Lulu.com

GET EBOOK

This book will show you how to modernize your page-based, include-oriented PHP application by extracting and replacing its legacy artifacts. We will use a step-
Pro T-SQL 2019
Language: en
Pages: 410
Authors: Elizabeth Noble
Categories: Computers
Type: BOOK - Published: 2020-02-12 - Publisher: Apress

GET EBOOK

Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book prov