Files
spring-data-demo/pagination/output/06-deep-offset-scan-count.txt

7 lines
318 B
Plaintext

# 100,000 rows in category 'bulk'. H2 EXPLAIN ANALYZE reports scanCount: rows the database read.
offset 0, fetch 10 scanCount: 10
offset 90000, fetch 10 scanCount: 90,010
keyset id > 90000, fetch 10 scanCount: 11
These are row counts, not timings. Timings depend on your database, indexes and cache.