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
- 13896 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
What is csv?
What is the use of mysqli_num_rows?
What are all the Common SQL Function?
How to change a password for an existing user via mysqladmin?
Where is mysql password stored?
What does mysql_query return?
Does facebook still use mysql?
How do I change the max connection in mysql?
What is innodb mysql?
How do I change the max connections in mysql?
What is the data source name for mysql?
What do you mean by % and _ in the LIKE statement?
Write command to import an mysql file?
How to calculate expressions with sql statements?
What is the default password for mysql?
