I am trying to rebuild my page to go from old-school recordset paging, to LIMIT paging. This will stop my query trying to load 100,000 rows when it really doesn't have to.

The problem I am having, is getting the count of all the records for that search. Before, I was getting the number of results by doing this:

```
recordCount = rsPhotoSearch.RecordCount

```

But now I have limited my query to 30, to show 30 records per page, my 'recordCount' only shows 30, instead of the 100,000 that it should be.

So how am I supposed to get the total number of records for that search, without going through all 100,000 rows, which to me, seems to defy the use of the LIMIT method? I could probably run a separate query, the same, just to count the records - but is that practical, because that will also go though 100,000 rows to get a count?

Any help gratefully received, as usual :)

From confused man