-
![[Cover]](../newcovers/9780596514976_cat.gif)
- Weitere Informationen zu diesem Buch:
JETZT ONLINE BESTELLEN
Refactoring SQL Applications
First Edition September 2008
ISBN 978-0-596-51497-6
296 Seiten,
EUR37.00
Kurzbeschreibung
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.
Ausführliche Beschreibung
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
Weitere Informationen zu diesem Buch
Inhaltsverzeichnis | Beispiele |
Ergänzende O'Reilly Titel:
 | Head First SQL |
