maxResults: the dynamic page size about data

[samdark]

How would such implementation look for SQL and array?

[kamarton]

It cannot be used with PHP arrays unless you are working from an external source.
Thinking about SQL, it can only be used for larger datasets.

without partitions:

SELECT * FROM ... WHERE larege_text like `%apple%` order by created_at LIMIT 3
// after 5 mins
// result: 1, 2, 1000000001

with date partitions:

SELECT * FROM ... WHERE larege_text like '%apple%' and date <= '2019-01-01' order by created_at LIMIT 3
// result: 1, 2
SELECT * FROM ... WHERE larege_text like '%apple%' and date <= '2019-01-01' and id > 2 order by created_at LIMIT 3
// result: -
SELECT * FROM ... WHERE larege_text like '%apple%' and date >= '2019-01-02' and date < '2019-01-03' order by created_at LIMIT 3
// result: -
...
SELECT * FROM ... WHERE larege_text like '%apple%' and date >= '2019-02-01' and date < '2019-02-02' order by created_at LIMIT 3
// result: 1000000001

This is only useful for scanner-based databases / data sources. Closable, thoughtful does not make sense in the framework.