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?
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 show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
How to check if value already exists in mysql database in php?
What is mysql database extension?
How to drop an existing table in mysql?
Can mysql scale horizontally?
What is int mysql?
How to rename an existing table in mysql?
How do I view mysql logs?
How do I edit a stored procedure in mysql?
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
Why we use mysql workbench?
What are the steps required to view your mysql database?
What is the hostname for mysql database?
How do I start mysql?
How do I find my mysql username and password?