Loading TOC...


Message Text

List cache full on host variable1


The query results are too large to fit all of the term lists resulting from the index resolution stage into the list tree cache.


Possible solutions include:

Tune the query to select fewer items during index resolution.Reduce the size of your forest data, which will lead to fewer results per query.Ensure appropriate indexes are enabled. For example, enabling positions may improve multi-term and proximity queries.Increase the size of the list cache in the group configuration.

If you increase your list cache size, be careful not to over-tune your system. If you decide to apply this solution and have a current maintenance contract with MarkLogic, MarkLogic Technical Support can assist you with selecting an appropriate cache size.

The size of all caches, both group and database related, should usually add up to less than half of physical memory.

Stack Overflow iconStack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.