[TYPO3-mvc] sort queryResult in code, not database

[Moritz Bützer]

Hi there,

we have a query that runs for around 2 minutes if we sort and group it in
mysql (lot's of joins, etc.)
we try to solve this problem by sort and group our result set (which is
pretty small) in code.

In our Tx_Extbase_Persistence_Repository we get a QueryResult using
$query->execute()

The paginate widget only accepts QueryResult object so we have to return one
of these object to the view.
What we can't figure out though, is how to create a differently sorted
QueryObject than the one we got from our acctual query.

Any ideas on that? (we know of course that we should sort it in mysql. we
really would if we could ;-))


Thanks a lot
Moritz