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

Answer Posted / nikunj

For increase speed of select query, there are some factor
like...
-By using Limit in query
-By using Index on table
-By using Primary key

Is This Answer Correct ?    17 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between base_url and site_url?

500


Which is useful for method overloading?

631


Which is better php or nodejs?

527


Tell me are parent constructors called implicitly inside a class constructor?

552


What is PHP's configuration file called?

577






List some of the features of php7.

546


What are advantages of .htaccess?

537


Are react hooks stable?

524


Can we learn php without html?

554


List some array functions in php?

509


what is mean by portal

1472


What is the difference between characters 34 and x34?

516


What is different between software and app

1235


Can we override static method?

535


What is the use of print_r function in php?

521