Use GSI to speed up query, no effect

[mburchard]

@geraldss

Did you measure MOI vs. standard GSI? The performance difference should be mostly in writes, not reads. Make sure the standard GSI has enough memory.

I mean the difference between

CREATE INDEX sf_user ON feeder (_eType,_oType,LASTNAME,FIRSTNAME) WHERE _eType = "GenericObject" and _oType = "SF_User"

and

CREATE INDEX sf_user ON feeder (_eType,_oType,LASTNAME,FIRSTNAME) WHERE _eType = "GenericObject" and _oType = "SF_User" USING GSI;

Isn’t that what’s different between MOI and standard GSI?
My Couchbase Server has 4GB RAM and tells me 3.79 is unused.