Revision history [back]
 | 1 | initial version |
The efficient way to obtain query results using the SKIP clause in Apache AGE is to combine it with the LIMIT clause. The SKIP clause specifies the number of rows to skip while the LIMIT clause specifies the maximum number of rows to return. By using the two clauses together, you can efficiently paginate through large result sets.
For example, to skip the first 10 rows and return the next 5 rows, you can use the following query:
MATCH (n:Node)
RETURN n
SKIP 10
LIMIT 5
This will skip the first 10 rows of the result set and return the next 5 rows. Using the LIMIT clause ensures that the query only returns a maximum of 5 rows, which can significantly improve performance when dealing with large result sets.