I’m using Couchbase 4.5.1 cluster with 2 nodes: node1, node 2 (both are VPS 8GB RAM, 4CPU, SSD)
When system perform a query, CB will do balance but I notice that, for the same query like this:
SELECT id FROM default t
WHERE type=‘Ads’ and loaiTin = 0 AND place.diaChinh.codeTinh=‘HN’ AND place.diaChinh.codeHuyen='15’
ORDER BY ngayDangTin DESC, timeModified DESC LIMIT 100 OFFSET 0
when run on node1 took 2400ms but when run on node2 took only 500ms. After look into it more closely I found out seem this is due to the index belong to node2:
Can you advice how to duplicate this index to node1 to speedup the query speed from node1 ?