I am looking for a good methodology for paging result sets of data, using a VFP7 DBC as a data source. My current method breaks down as the original table gets large. This is for serving the table rows on the web.

Currently I am doing this:

Get RecCount() of table (now 100,000 rows and growing)
Divide Int( RecCount() / iRows + 1 )to get total number of pages
If I want the first page
Multiply total number of pages * page wanted to get bottom page row number
Add number of rows wanted + bottom range row to get top range row number
Select * from table where RecNo() between bottom and top row number wanted

What are you guys doing?