jeudi 29 janvier 2015

Record count from LIMIT query

We are using a LIMIT/OFFSET query with the FMDB library. I know that I can easily get a count from the FMResultSet, but because we only return a subset of the records it will not be the count of the available records. Does anyone know if there is a DB variable I can call that will give the total count from the previous query? Trying to avoid issuing a full count query due to performance concerns.


Thanks in advance!


Aucun commentaire:

Enregistrer un commentaire