[TYPO3-50-general] Persistence: How to implement limit and offset?

[Jochen Rau]

Hi.

After having implemented the parsing of orderings I tried to implement 
limit and offset in Extbase - and stuck.

One can specify $query->setLimit() and $query->setOffset(). But the 
JCR283 specs do not allow to "forward" these settings to the Query 
Object Model and thus to the Storage Backend. The only two solutions I 
found (beeing JCR283 compliant) was to read all the data from the 
database and then drop most of the rows, or to perform two queries 
(search and fetch). Both are IMO not advisable.

Any clue?

Jochen


-- 
Every nit picked is a bug fixed