Re: [HACKERS] Efficiency of LIMIT ?

In article <199904251941.PAA00652@candle.pha.pa.us>,
Bruce Momjian <maillist@candle.pha.pa.us> wrote:
>> > Is the LIMIT feature very efficient? I want to start using it for quite
>> > a few things, but I'm wondering, what happens when I have a zillion
>> > records and I want the first 10, is that going to be an efficient thing
>> > to do?
>> 
>>     I am curious about this myself.  As far as I can tell, it doesn't
>> give anything that cursors don't provide, but introduces more "features"
>> into the parser.  Do we need this?
>
>This is pretty correct, though it stops the executor from completing all
>the result queries, while cursors don't.  The complete the entire query
>and store the result for later fetches..  We support it because MySQL
>users and others asked for it.

It is a nice touch for web interfaces that are going to display
so many records for a request and not maintain any state between
requests.
 Les Mikesell   les@mcs.com