Beginning MySQL Database Design and Optimization: From Novice to Professional - Softcover

Russell, Chad; Stephens, Jon

  • 4.30 out of 5 stars
    10 ratings by Goodreads
 
9781590593325: Beginning MySQL Database Design and Optimization: From Novice to Professional
Softcover
ISBN 10: 1590593324 ISBN 13: 9781590593325
Publisher: Apress, 2004

Synopsis

Nearly every non-trivial application requires data persistence, and for an application of any significant size and scope, persistence is typically achieved using a database. If you’re building or maintaining any significant application and are using MySQL, this book is for you. For open source and other types of projects, the MySQL database is a very popular choice: it’s free, fast, robust, and scalable, and it runs on all of the major platforms, allowing maximum use of available hardware resources. But it’s easy to disregard MySQL’s speed and other advantages if your database design is inefficient. Needlessly duplicating data, using improper types for columns, overloading a single table where multiple tables should be used, failing to leverage the calculation features of MySQL, and making multiple queries instead of an efficient single query are some of the common mistakes.

Beginning MySQL Database Design and Optimization shows you how to identify, overcome, and avoid gross inefficiencies. It demonstrates how to maximize the many data manipulation features that MySQL includes. This book explains how to include tests and branches in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. You’ll also learn about some features new to MySQL 4.1 and 5.0 like subqueries, stored procedures, and views, all of which will help you build even more efficient applications.

"synopsis" may belong to another edition of this title.

About the Author

Chad Russell is a programmer and network administrator who owns his own Internet hosting company. He previously has written on MySQL, PHP, and other topics.

"About this title" may belong to another edition of this title.

Publisher
Apress
Publication date
2004
Language
English
ISBN 10 
1590593324
ISBN 13 
9781590593325
Binding
Paperback
Edition number
1
Number of pages
540
Rating
  • 4.30 out of 5 stars
    10 ratings by Goodreads

Other Popular Editions of the Same Title

9781430252337: Beginning MySQL Database Design and Optimization: From Novice to Professional

Featured Edition

ISBN 10:  1430252332 ISBN 13:  9781430252337
Publisher: Apress, 2013
Softcover