Query service results caching


#1

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?


#2

Hi, please see the documentation on N1QL prepared statements. That is the caching in question.