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
- 14866 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 data type is money?
What is normalization and list the different types of normalization?
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
What is pdo :: fetch_assoc?
How you can create a trigger in mysql?
How can I compare two mysql databases?
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
How to create a new view in mysql?
How to present a past time in hours, minutes and seconds?
Where is the mysql data directory?
what are the different tables present in mysql? : Mysql dba
Is mysql query case sensitive?
How do I fix a crashed mysql database?
What is mvcc in mysql?
What is a storage engine? What are the differences between innodb and myisam engines?
