Interested to Buy Any Domain ? << Click Here >> for more details...
A select query over a large table runs very slow because of
the growing number of entries in that table. What different
measures could be taken to improve speed?
- 5 Answers
- 14795 Views
- I also Faced
- E-Mail Answers
Answer Posted / dhirendra
Myself also faced the problem and after indexing its
resolved.
Try to find out the feild name on which maximum query
executed. Create index on that field it will improve the
performance.
Secondly you may create archiev of you table which stores
the record which is not required and deletion or updation
activity and keep the current table light.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How to Set a root password if there is on root password.
What are the different data types in mysql?
Should I use pdo or mysqli?
What is the full form of mysql?
What is prepare statement in mysql?
Explain % and _ inside like statement?
In which language it is written?
How can I connect mysql database?
How do I install mysql?
How do I install mysql on windows 7?
What is clob datatype?
Explain the difference between delete and truncate.
what is the difference between between and in operators in mysql?
How do I select a database in mysql?
How do I rename a procedure?
