> We have tried out the patch: > https://review.openstack.org/#/c/592698/ > we also applied https://review.openstack.org/#/c/592285/ > > it turns out that we are able to half the overall time consumption, we > did try with different sort key and dirs, the results are similar, we > didn't try out paging yet: Excellent! Let's continue discussion of the batching approach in that review. There are some other things to try. Thanks! --Dan