MapReduce - view takes over 20+ seconds with skip value


I’m having hard time optimizing my view.

I have the following view

function (doc, meta) {
    if (
        // conditions
    ) {

        doc.values.enabledProductTypes.forEach(function(item) {

            // index enabled item only
            if (item.enabled === true) {
                emit(item.productTypeId, parseInt(;



Reduce: _count

Without any key set, reduce outputs 48 millions.

When I set a key then I get 3 millions records.

the following works just fine.


When I set skip to 3,000,000, then the view takes over 20+ seconds.


How do I make skip faster?

Update1: Looks like there is no way around it, except setting startkey_docid according to