How can we increase the speed of a MySQL select query?
MySQL | Increase the speed of a MySQL select query
For increasing the speed of a query we have to do a couple of things
- First of all instead of using select * from table1, use select column1, column2, column3.. from table1.
- Try to introduce the index in the table.
- Always use the limit keyword if we are looking for any specific number of rows from the result set.