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
- 15044 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is mysqli procedural?
What is the difference between mysql_connect and mysqli_connect?
What are the differences between mysql vs sql server?
How do I select a database in mysql workbench?
What does mysqli stand for?
Where is mysql data stored?
How do I set user privileges in mysql?
How to create a new view in mysql?
How do you connect MySQL database with PHP?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
what is the default port for mysql server? : Mysql dba
What is blob storage?
What is memory table in mysql?
What is latest version of mysql?
What is definer in mysql?
