How can we optimize or increase the speed of a MySQL select query?
March 4, 2014
- first of all instead of using select * from table1, use select column1, column2, column3.. from table1
- Look for the opportunity to introduce index in the table you are querying.
- use limit keyword if you are looking for any specific number of rows from the result set.