NSFetchRequest fetchOffset pagination: latency growth as a failure condition for large datasets
Core Data’s NSFetchRequest supports bounding a query with an NSPredicate and limiting results with fetchLimit . Pagination is commonly implemented by advancing fetchOffset to skip previously fetched rows. With the SQLite store, the documented behavior is that the store still evaluates the full predicate and sort ordering before skipping rows, so execution ti