> if I'm not mistaken, it's called partial sorting, when you stop
> sorting process after getting desired number of rows specified by LIMIT clause.
> it's extremely friendly for web applications, because 90% of users
> just read the first page of results. We already discussed this feature
> sometime during 7.1 dev and even made very crude patch. In our tests we
> got performance win of factor 5-6 ( getting first 100 row from 1mln ).
> We hope sometime we'll return to this.
But we already have cursor's assuming 10% return. Is allowing that
value to be changed using SET an acceptable solution?
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026