igormiletic commented :
Any work planned on this soon? We are expressing this as well and we realized that as offset get bigger and bigger query become slower and slower.
We have about 30.000.000 nodes and we have case that we need to export some data to AWS S3 (to make it available for Athena queries). It is almost impossible to extract all nodes using pagination as query become slower and slower as offset increase.