Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
09-02-2020 10:12 AM
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
09-03-2020 02:09 PM
If you don't specify an ORDER BY then you are telling neo4j you don't care what order the results come back in.
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.
All the sessions of the conference are now available online