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 / sanjeev vishu
To improve select query speed we must use paging.
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
How to get data from mysql in php?
How many entries can mysql handle?
Where MyISAM table will be stored and also give their formats of storage?
What is the difference between sql and mysql and oracle?
How do I assign a variable in mysql?
How do I know if mysql is installed on windows?
What are different types of queries?
Can mongodb replace mysql?
What are the similarities between a function and a procedure?
In how many ways we can retrieve data in the result set of mysql using php?
Is mysql an oracle product?
Is mysql relational?
How do I start mysql database?
What is mysql_query?
Why we use mysql workbench?