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

Write a program in php to find the occurrence of a word in a string?

871


What type of headers have to be added in the mail function to attach a file?

750


What is form submission?

752


How is a session id generated?

747


How does one prevent the following warning ‘warning: cannot modify header information – headers already sent' and why does it occur in the first place?

720


What are the Formatting and Printing Strings available in PHP?

798


Tell me how do you define a constant?

721


What is super () python?

751


How does php isset work?

728


How does php serialize work?

721


Explain what does $_files means?

785


Can I use php in visual studio?

747


So if md5() generates the most secure hash, why would you ever use the less secure crc32() and sha1()?

805


Does empty check for null?

741


What is php and what does it do?

804