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
- 14674 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 many rows can be inserted in mysql at a time?
What is acid in mysql?
Where MyISAM table will be stored and also give their formats of storage?
Why myisam is faster than innodb?
What are the purposes of using enum and set data types?
Can I use mariadb instead of mysql?
Why phpmyadmin is used for mysql?
What is difference between schema and table?
How show all tables in mysql query?
How do I install the latest mysql on ubuntu?
How we can see all indexes defined for a table in mysql?
How do I edit a table in mysql?
What is the usage of ENUMs in MySQL?
Is mysql and sql are same?
Is mysql frontend or backend?
