Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

What is the use of mysqli_fetch_array?

0 Answers  


How to show all tables with 'mysql'?

0 Answers  


How many primary keys can be there in a table?

0 Answers  


Explain the architecture models of SQL Server?

0 Answers  


What is the difference between mysql and oracle?

0 Answers  






How do I restore a mysql database?

0 Answers  


The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?

4 Answers   Afixi, GE,


What is a mysql view?

0 Answers  


What are the security alerts while using mysql?

0 Answers  


How does mysql clustering work?

0 Answers  


How to create a new table by selecting rows from another table in mysql?

0 Answers  


What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

0 Answers  






Categories