Order from a Major Online Bookstore
Ultimate Book Price Comparison Engine
Save Your Time And Money
| AnyBook4Less.com | Order from a Major Online Bookstore |
|
| Home | Store List | FAQ | Contact Us | | ||
| Ultimate Book Price Comparison Engine Save Your Time And Money |
||
 |
Title: SQL Performance Tuning by Peter Gulutzan, Trudy Pelzer ISBN: 0-201-79169-2 Publisher: Addison-Wesley Pub Co Pub. Date: 10 September, 2002 Format: Paperback Volumes: 1 List Price(USD): $44.99 |
Average Customer Rating: 4.67 (6 reviews)
Rating: 5
Summary: very well written RDBMS book
Comment: Over the years I've developed a number of systems that utilized relational databases. When I developed or used a complex and/or large database, more often than not I found that database performance was the main issue, especially in real-time or near real-time applications. I have been interested in the databases *only* to the point of satisfying my projects' needs and considered them subordinate to the rest of the systems. I did realize the complexity of RDBMSs implementations, but never cared to learn more than I necessary to solve an immediate problem at hand. Maybe this is why I've never really enjoyed reading about the databases: I believed that the databases and SQL were quite boring comparing to all the elegance and slickness of C++, Java, CORBA, and other object-oriented technologies.
"SQL Performance Tuning" changed my perception of that; I was hooked just after just a few sentences. The language, the obvious depth of the authors' knowledge, the wide and careful coverage of all related issues, including the very fundamentals of the relational databases are presented as needed; and mostly, the enjoyably right balance between the theory and practice makes this book an outstanding read. I have not read most of it yet, but I am very excited about what I will find in the rest of it, even if it is something that I think I know well.
Rating: 5
Summary: A deeper look at SQL queries
Comment: There's a lot of ground to cover between being able to put together a SQL query that runs and being able to construct a query that works well. The journey is all the more complicated when you're trying to target multiple RDBMSes, each with its own nuances and oddities. That's where this book shines. By going for breadth--picking 8 major RDMBS and contrasting how they behave in the face of various SQL constructs and optimizations, plus covering some general theory, this book conveys a quality of information that vendor-specific books lack. I knew a fair amount about databases and SQL before picking up the book, and came away with a much better feeling for the terrain, and a new set of optimization tricks.
It's unfortunate, but perhaps unavoidable, that some details (e.g. lack of information on transactions and subselects in MySQL) where out-of-date by the time the book was published. It's also unfortunate that the authors were prevented by vendor license agreements from providing performance hard numbers.
Don't get this book to learn how to optimize for a particular vendor's database. Study it to broaden your skills.
Rating: 3
Summary: Not enough vendor-specific detail
Comment: The book gives many examples of how to fine-tune SQL statements, and usually displays performance gain/loss resulted from the fine-tuning right below the examples. But the result is shown in the format "##/8", meaning the DBMS's of ## vendors out of the "big 8" show performance gain. For me this information is not too much helpful, since I only work on Microsoft SQL Server and am not very interested in other verdors. If the book can give more vendor-specific examples and explanations it will be more helpful, at least for me.
 |
Title: Database Administration: The Complete Guide to Practices and Procedures by Craig S. Mullins ISBN: 0201741296 Publisher: Addison-Wesley Pub Co Pub. Date: 14 June, 2002 List Price(USD): $44.99 |
 |
Title: DB2 SQL Procedural Language for Linux, Unix and Windows by Paul Yip, Drew Bradstock, Hana Curtis, Michael X. Gao, Zamil Janmohamed, Clara Liu, Fraser McArthur ISBN: 0131007726 Publisher: Prentice Hall PTR Pub. Date: 24 December, 2002 List Price(USD): $49.99 |
 |
Title: Joe Celko's SQL for Smarties: Advanced SQL Programming by Joe Celko ISBN: 1558605762 Publisher: Morgan Kaufmann Pub. Date: 01 October, 1999 List Price(USD): $44.95 |
 |
Title: Microsoft SQL Server 2000 Performance Tuning Technical Reference by Marcilina Garc Edward Whalen ISBN: 0735612706 Publisher: Microsoft Press Pub. Date: August, 2001 List Price(USD): $49.99 |
 |
Title: Joe Celko's SQL Puzzles and Answers by Joe Celko ISBN: 1558604537 Publisher: Morgan Kaufmann Pub. Date: 01 March, 1997 List Price(USD): $28.00 |
Thank you for visiting www.AnyBook4Less.com and enjoy your savings!
Copyright� 2001-2021 Send your comments
