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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / jd
This question cannot be answered with the way it is formulated.
One has to run a trace to figure out why the select is slow.
it could be a lack of index, it could be bad storage
parameters, it could be that the select itself is written
poorly.
Too many problem can be described by this symptom.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sanjeev vishu
To improve select query speed we must use paging.
Is This Answer Correct ? | 4 Yes | 8 No |
List some comparisons operators used in mysql?
What port is mysql running on?
what is the difrence between sql and pl/sql
How to dump one database for backup.
What is Database?
Is mysql from oracle?
What is the difference between having and where clause in mysql? Explain
How to drop an existing index in mysql?
Can you tell how to find the number of rows in a resultset using php?
Is mysql distributed?
What are the features of mysql?
How many rows can mysql hold?