Re: how to handle Pagination >

You will probably want to use OFFSET and LIMIT, which are the window size
and page. Something like

SELECT .. FROM ... WHERE ... ORDER BY (...) OFFSET y LIMIT x

So say you want to get 100 records at a time. You would get page 1 with
OFFSET 0 LIMIT 100, then page 2 with OFFSET 100, OFFSET 200, and so on.

That's just off the top of my head. There may be another solution which
will work better in your case, but lacking details, this is what I would
recommend.

--
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GIT d+ s: a-- C++++(++) UL+++ P++++$ L+++>++++ E- W+ N o? K w--- O-
M- V? PS+++ PE(-) Y+ PGP->+++ t+>++ 5+++++ X(+) R>+ tv b+
DI++ D++>+++ G+ e* h! !r y**
------END GEEK CODE BLOCK------