ACCU Home page ACCU Conference Page
Search Contact us ACCU at Flickr ACCU at GitHib ACCU at Google+ ACCU at Facebook ACCU at Linked-in ACCU at Twitter Skip Navigation

Search in Book Reviews

The ACCU passes on review copies of computer books to its members for them to review. The result is a large, high quality collection of book reviews by programmers, for programmers. Currently there are 1918 reviews in the database and more every month.
Search is a simple string search in either book title or book author. The full text search is a search of the text of the review.
    View all alphabetically
Title:
SQL Performance Tuning
Author:
Peter Gulutzan and Tmdv Pelzer
ISBN:
0-201-79169-2
Publisher:
Addison-Wesley
Pages:
528pp
Price:
$44.99 (no UK p
Reviewer:
Christopher Hill
Subject:
database
Appeared in:
15-3
Take eight computers. Install a different database system on each (MySQL is included in the eight). Then work your way through the SQL language seeing how you can make significant portable improvements in performance.

This book is a labour of love. The authors try out all the wheezes and 'everybody knows that.' to produce a catalogue of ways to write portable SQL code (ANSI/ISO standard SQL:1999) that works swiftly over the major platforms.

The relative performance of the database is not compared (this is prohibited by the vendors) but for each item two snippets of SQL are compared and if there is a better than 5% improvement on a platform it gets an 'improvement' tick. Most items get 8 ticks. A very few have a negative impact on particular platforms.

The first third of the book covers the main parts of the SQL that cause bottlenecks: simple searches, Order By, Group By, Joins and Subqueries. They then move on to the physical aspects; Columns, Tables, Indexes, Constraints and Stored Procedures. The final third looks at ODBC, JDBC, Locks, Client/Server and Cost-based Optimisation.

Given the subject matter, inevitably the book has a 'cook book' feel, although the writing style does a great deal to reduce this. There is plenty of background information on why you should use this technique over another, so you can decide which is best for your circumstances. Some solid theory is also presented (including Btrees and normalisation) in a very approachable manner.

'Your DBMS is your pal. You should try to get to know it better and help it to help you'. This should not be your first book on SQL, but every DBA and SQL writer should have a copy to hand. Highly recommended.