We are now working 2 years with Neo4j and do a lot of performance checks.
We are search a lot about sorting many nodes and we do not found a good solution.
Only when i do a sort like;
MATCH(message:Message) RETURN message ORDER BY message.changed_on DESC LIMIT 10
Cypher version: CYPHER 3.4, planner: COST, runtime: COMPILED. 6600415 total db hits in 34132 ms.
What is the best way to do this?