Neo4j: Cypher – Profiling ORDER BY LIMIT vs LIMIT
Mark Needham discusses some of the differences between using the “LIMIT” operator versus using the “LIMIT” operator with the “ORDER BY” operator with Neo4j
Something I’ve seen people get confused by when writing queries using Neo4j’s cypher query language is the sometimes significant difference in query execution time when using ‘LIMIT’ on its own compared to using it in combination with ‘ORDER BY’.
The confusion is centred around the fact that at first glance it seems like the only thing different between these queries is the sorting of the rows but there’s actually more to it.
Read the Full Article Here.