By using LIMIT we can improve speed.

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 / dinesh goyal

5 Answers
14797 Views
I also Faced
E-Mail Answers

Answer Posted / dinesh goyal

By using LIMIT we can improve speed.

Is This Answer Correct ?

5 Yes

10 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does do in mysql?

857

What are the 'mysql' command line arguments?

992

What is the limitation of mysql?

945

What is the data type for file in mysql?

972

How do I start and stop mysql on windows?

990

Can we rollback truncate in mysql?

991

What are federated tables?

1157

What is pdo :: fetch_assoc?

884

Explain timestamp?

949

How to concatenate two character strings?

1009

How to enable or disable a row of a table using MySQL in struts?

4075

How to insert html code into mysql database using php?

1041

What is blob in mysql?

996

What is pdo in mysql?

905

What is the current root password of mysql?

891