[fw-general] Lucene limit for pagination

[iffy guy]

Is there a way to limit the number of rows for pagination in lucene? IF the
file has millions of rows and returns say about 10k rows for a search (all
rows), the server's memory would bog down to load 10 k rows into memory,
right? How are others handling this situation?