I have 35 million records in couch base and I am querying using following query -
SELECT TestBucket1.* FROM
TestBucket1 WHERE type=“individual” ORDER BY META().id OFFSET :offset LIMIT 10000;
where offset will increase by 10000 every time new query fires .
But above query is taking long time and keeps on executing .
I have also created indexes on META().id as well as on type , still no improvements .
What can be other ways to execute same ?