Writing a good optimized sql queries will help to reduce server load on MySQL and also improves the load time and server response time for the web page.
Few tips to optimize MySQL queries are below:
1. Select only required colums:
Selecting every thing from the table will cause more memory uses and thus utilize more server resources.
SELECT * FROM <TABLE>;
SELECT name, age FROM <TABLE>;
Only select required fields to have better performance.
2. Indexing correctly:
Index is not only for primary key, we should index field that is search contineously, and also the joined column.
Select name, age from table where age=32 and name =’alex’ ;
Select name, age,group from table1 left join table2 on table1.groupid=table.group where age=32 and name=’alex’;
In first case, name and age should be indexed. ( Way of indexing will be covered in next blog).
In second case, along…
Ver la entrada original 462 palabras más