Database optimization has become crucial to web developers for improving the performance of web applications and thus bettering user experience. If you optimize your database properly, you’ll improve performance, reduce bottlenecks, and save resources. There are some optimization techniques that don’t require DBA-level expertise in SQL-queries.
Table of contents
1. Use EXPLAIN with Your SELECT Queries2. Add Indexes to Searched Columns3. Use Identity Fields Whenever Possible4. Avoid NULL Values by Default5. Use the Unbuffered Mode With Queries6. Make Your Columns Compact7. Keep Your Tables Static (Fixed-length)8. Install an Object-Relational Mapper (ORM)9. Run DELETE and UPDATE Queries in Batches10. Use PROCEDURE ANALYSE() to Get More Tips1 Comment
Sort: