1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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?

Question Posted / pranab

Answers were Sorted based on User's Feedback



A select query over a large table runs very slow because of the growing number of entries in that ..

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

A select query over a large table runs very slow because of the growing number of entries in that ..

Answer / kalaivani

select the required field from the table

Is This Answer Correct ?    3 Yes 1 No

A select query over a large table runs very slow because of the growing number of entries in that ..

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

A select query over a large table runs very slow because of the growing number of entries in that ..

Answer / sanjeev vishu

To improve select query speed we must use paging.

Is This Answer Correct ?    4 Yes 8 No

A select query over a large table runs very slow because of the growing number of entries in that ..

Answer / dinesh goyal

By using LIMIT we can improve speed.

Is This Answer Correct ?    5 Yes 10 No

Post New Answer

More MySQL Interview Questions

How to drop an existing view in mysql?

1 Answers  

Why should I use mysql?

1 Answers  

What is mysqli_free_result?

1 Answers  

What are the types of index?

1 Answers  

what programming language which is used for testing and developement in sql?

3 Answers  

How to store values to array from mysql database in php?

1 Answers  

What is the use of procedure in mysql?

1 Answers  

How big is a blob mysql?

1 Answers  

How we can see all indexes defined for a table in mysql?

1 Answers  

How do I insert an image into mysql workbench?

1 Answers  

What you can use regular expression for in mysql?

1 Answers  

What is the difference between b-tree and hash indexes?

1 Answers  

For more MySQL Interview Questions Click Here
Categories