This has been asked before. I am just checking if we found a better way since this was posted:
https://community.neo4j.com/t5/neo4j-graph-platform/get-count-before-limit/td-p/38055
https://stackoverflow.com/questions/44478680/getting-results-count-from-a-query-with-limit-clause
1. I find it weird writing 2 MATCH queries, one for count and one for returning a subset of results (with SKIP/LIMIT). Is this still the recommended approach?
2. This SO post by @michael.hunger recommends running 2 MATCH queries over 1 query and collecting sliced results for skip/limit. Can someone please explain why running 2 queries is more efficient?