How can we optimize or increase the speed of a mysql select
query?

Answer Posted / senthilkumar

1.Select <fieldname> from tablename.
2.Limit Setting.
3.Index Using
4.Primary key..

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between Split and Explode in PHP?

797


How to take a substring from a given string?

716


Is gender a dependent variable?

726


What is full form of php? Who is the father or inventor of php?

748


How to create a table to store files?

745


How to change the principal password?

785


What are the three classes of errors that can occur in php?

790


Why php is widely used?

703


What is the default time of cookie in php?

705


Which is better php praogramming or cad/cam scope wise and also salaray wise?

1771


Can I write php code in html file?

723


How to return a value back to the function caller?

752


Name some of the popular frameworks in php.

744


What is difference between static and final in php?

749


What is the role of php?

725