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.
Friday, December 4, 2009
How can we optimize or increase the speed of a MySQL select query?
# 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.
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment