How can we optimize or increase the speed of a mysql select
query?
- 6 Answers
- 16289 Views
- I also Faced
- E-Mail Answers
Answer Posted / shanmuga
Using Proper Index.
Using LIMIT
using Primary KEy.
Important : Whenever the huge no of updation or deletion
happened in that table use OPTIMIZE TABLE command.This will
reduce the unused space.
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
What is the difference between php and cakephp?
Is python similar to php?
Explain preg_Match and preg_replace?
What is the purpose of $_ session?
"mysql_fetch_row — Get a result row as an enumerated array",this sentence comes from the PHP offical manual.However ,i can not understand the words "enumerated array".I need some help.Thanks a lot to everyone that reply.
Tell me how comfortable are you with writing html entirely by hand?
What is an associative array?
Do loops php?
What is phpsessid?
How to convert strings to upper or lower cases?
What enctype is required for file uploads to work?
What is a session in php?
In php, how to redirect from one page to another page?
Which parts of php are case sensitive?
What is the difference between static and dynamic websites?
