Document size and query performance

Hi,

I just have a question - does the size of a document that is stored in Couchbase affect the performance of a query performed against this document or a set of documents? Will a query be faster with smaller documents or does it matter if all documents are loaded into RAM anyway?

Any information is very helpful and appreciated,
Killian

Yes. Impacts. If document is bigger, it needs more memory to store,process,transport etc. Query service is different process than Data Service and it can reside on same or different machine.

Just a small comment, if you have big documents you should create indexes for specific fields you are commonly searching for, it will minimize a lot the performance impact of scanning big documents in your queries

Thank you both for the comments. They were both very helpful!