forum by: user: admin, Post on: 2021-09-24 20:37:58, Posts: 129
how to make mysql_query faster
how to make mysql_query faster
user: admin / Posts: 45 / post on: 2022-01-13 20:00:11
how to make mysql_query faster
a. Normalize Tables
b. Use Optimal Data Types
c. Avoid Null Values
d. Avoid Too Many Columns
2. Optimize Joins
3. Index All Columns Used in 'where', 'order by', and 'group by' Clauses
4. Use Full-Text Searches
5. Optimize Like Statements With Union Clause
6. MySQL Query Caching
Tips to Improve MySQL Query Performance
1. Optimize Your Databasea. Normalize Tables
b. Use Optimal Data Types
c. Avoid Null Values
d. Avoid Too Many Columns
2. Optimize Joins
3. Index All Columns Used in 'where', 'order by', and 'group by' Clauses
4. Use Full-Text Searches
5. Optimize Like Statements With Union Clause
6. MySQL Query Caching
Post User for this topic: title
Please Login to replay:
Login |
Register