cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

If data no change, order of result is fixed?

If data no change in neo4j, the ordering of relationships is fixed without use order by?

I need to read large relationships in partitions of spark, different partition with different skip/limit, But can't use the index in relationships property, it uses time with order by is can't accept at all.

So I wonder that when data no change in neo4j, Can neo4j guarantees every time I query to get the same order result?

My neo4j version is 3.5

1 REPLY 1

If you don't specify an ORDER BY then you are telling neo4j you don't care what order the results come back in.

More on this here

In your case, my first thought would be to try specifying what you see is the current default ORDER BY and check if performance is acceptable (it might be fast)

The thinking here is to specify an ORDER BY to assure we know how it is ordered, then if the default order changes in the future the query may slow down, but at least we've guaranteed that it will not return results in an unexpected order.