top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

How can I Optimize the speed of a MySQL Select Query?

+1 vote
70 views
How can I Optimize the speed of a MySQL Select Query?
posted May 6, 2014 by Mohit Sharma

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

+1 vote

Few Suggestion hope it will help you:
1. Instead of using select* from table, use select column1, column2, column3.... from table 1.
2. Look for the opportunity to introduce index in the table you are querying.
3. Use Limit keyword if you are looking for any specific number of rows from the result set.

answer May 7, 2014 by Rahul Mahajan
Similar Questions
+2 votes

I have moderate level PHP programming skills. I am also interested in merging those skills inside of the WordPress app. With their advanced responsive design themes and many other functions it seems like a good idea. I have tried loading some PHP plug-ins in WP – but I don't seem to get them to do more than basics.

Can anybody help me on how I can get started working with PHP/MySQL inside of the WordPress app?

+1 vote

Joiner using how to get three tables value fetching from single query.

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...