> Whereas with the SELECT...LIMIT paradigm, the database engine does NOT
> process the entire huge query, it quits processing once it reaches the
> limit. (Well, at least MySQL does so, if you happen to be using an
> "ORDER BY" supported by an index). Obviously doing 1/4th the work four times
> is better than doing the whole tamale four times :-}.
And no join, I assume.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026