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

Do you know is it possible to extend the execution time of a php script?

788


How are cookies created?

737


How to register a variable in PHP session?

717


What is php oop?

710


Is set in php?

735


How do you end php?

721


How can you upload a file using php?

743


Explain what does $_server means?

806


How to find length of an array in php ?

755


what are the differences between php and perl

1786


Is empty in excel?

725


What is the use of callback in php?

719


How do we get the current session id?

761


What are majic methords in php?

820


How to create a session? How to remove data from a session?

729