CODEWITHSUNDEEP
neo4jpaginationcyphermassive
Trustiser-Habiba
Trustiser-Habiba

Reputation: 11

How to paginate results of cypher, neo4j?

i am currently working with neo4j, if anybody knows how to do pagination with the results that a cypher query gives, specialy the size of the results is so big, about 100 millions.

i know the methode of skip and limit and order by (which is not good, it takes a long time). so is there anyone knows another efficient methode to do the pagination.

thank you in advance.

Upvotes: 1

Views: 825

Answers (2)

canbax
canbax

Reputation: 3856

Actually, you don't need order by clause. You can use SKIP and LIMIT like RETURN x SKIP 0 LIMIT 15. I think its performance should be better.

Upvotes: -1

cybersam
cybersam

Reputation: 66999

The APOC periodic execution procedures may work for you.

For example, apoc.periodic.iterate allows you to execute a query (referred to as the "inner query") in batches of a specific size.

Upvotes: 0

Related Questions