[rogue]

I'll wager that all 100,000 rows are being selected, then sorted then 20 are re-selected.

Try taking the 'order by' out of the select and see if that makes a difference.

I'm not sure what you can do if this is indeed the case.