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

Question

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?

Answer 1

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.