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
# Use limit keyword if you are looking for any specific number of
rows from the result set.

No comments:

Post a Comment

I just got my #domain @BigRock. Get upto 25% off with my personalized coupon link Get upto 25% off