Any guidance on the query service cache settings? I have read this in the docs:
“Query service manages its memory to calculate query responses by processing streams effectively for the execution plans generated by the optimizer and caches certain parts of those query plans.”
I see significantly faster performance when a n1ql query is repeated into couchbase and I would like to scale out the query service to take advantage to what looks like result set cacheing. How should I modify the available RAM settings to maximize the amount of memory available to the query service?