I am using Couchbase 5.1 and I am using Views for quering documents.
My data bucket contains aroung 1.5 million documents, which also contains documents with attachments (images).
My bucket has weight aroung 800 Gb right now.
When I create new View it takes around 12 hours to be built. During this time my server is not responsive since I/O read operation is taking almos all disk throughput.
Why is it so slow? It is only 1.5 millon documents?
Does couchbase process images as well when it create Views? If so how to avoid this?
Should I move my data to separate buckets like one for images docs and other data for second bucket?