Top 20+ MySQL Best Practices
Database operations often tend to be the main bottleneck for most web applications today. It’s not only the DBA’s (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. Here are some MySQL optimization techniques for programmers.
Related Submissions:
- Optimizing MySQL Queries with LEFT JOIN This week, I wanted to share some of my recent experiments with MySQL queries in regard to lowering the number of requests sent to the...
- Copying Tables in MySQL Whether you need to copy a test table to a production database, or you need to duplicate a table with only some selected rows or...
- Using MySQL Alongside PHP - Part One A short tutorial for beginners to PHP and/or MySQL that shows the basics of using a MySQL database to create a list of clients. ...
- Expanding Our MYSQL Class to Include Caching Building on last week’s article about closing mysql connections, I wanted to pass on this further expanded class, that allows for caching on heavier queries....
- Vital Tips for Working with MySQL Databases MySQL is one of the most popular relational database management systems (RDBMS) around, with over 6 million installations. It’s a fantastic choice for any new...