[macintosh]

I have a database with huge number of records. I run the select query, something like,
Select * from abc where post_author =xyz, it takes lots of time.

I did read that in huge databases, the queries should be done by using LIMIT .Can someone please help me using LIMIT parameters in every step? any example, would be very appreciated.

[wirehopper]

There are lots of ways to speed up queries. Do you have an index on the table?

Limit: MySQL :: MySQL 5.5 Reference Manual :: 12.2.9 SELECT Syntax

Indexes: MySQL :: MySQL 5.5 Reference Manual :: 12.2.9.2 Index Hint Syntax

Top10SQLPerformanceTips - MySQL Forge Wiki