top button
Flag Notify
Site Registration

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

+1 vote
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 LinkedIn 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.