Beginning MySQL Database Design and Optimization

Beginning MySQL Database Design and Optimization

4.11 - 1251 ratings - Source

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 youa€™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: ita€™s free, fast, robust, and scalable, and it runs on all of the major platforms, allowing maximum use of available hardware resources. But ita€™s easy to disregard MySQLa€™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. Youa€™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.(We name the table app_users rather than users in order to avoid any confusion with MySQLa#39;s own mysqLuser table.) ... a#39;SPANISHa#39;) _; )Query OK: 0 rows affected (0.03 sec) mysqlagt; INSERT INTO app_users (app_user_id, username, language) anbsp;...

Title:Beginning MySQL Database Design and Optimization
Author: Chad Russell, Jon Stephens
Publisher:Apress - 2004-10-27

You must register with us as either a Registered User before you can Download this Book. You'll be greeted by a simple sign-up page.

Once you have finished the sign-up process, you will be redirected to your download Book page.

How it works:
  • 1. Register a free 1 month Trial Account.
  • 2. Download as many books as you like (Personal use)
  • 3. Cancel the membership at any time if not satisfied.

Click button below to register and download Ebook
Privacy Policy | Contact | DMCA