Previous Topic: set cache-index Command—Specify Attributes to Be Indexed

Next Topic: set cache-reverse Command—Specify Which Cached Attributes to Reverse-index

set cache-index-all-except Command—Specify Attributes Not to Index

This new command defines which attributes will not be indexed. This lets you reduce the amount of indexes that are loaded into memory.

This command behaves like cache-index-all except that it also allows you to specify a number of attributes that will not be indexed. It may be simpler to specify all except" than to give a complete list of attributes to index, as for cache-index, especially as trying to specify all attributes to index may not cover new attributes that are added in the future.

It may be necessary to limit the number of attributes that are indexed as indexing an attribute requires additional memory. If indexing all attributes would consume all the memory allocated to DXgrid, this command could help tune the memory requirements.

It is a good idea to index attributes, because searches require indexes to evaluate their filters. Also, indexes are required to find specific entries that are targeted by updates. On the other hand, searches may still proceed even where few attributes are indexed, but they may take much longer to process. There is therefore a trade-off between memory and performance. Where memory is not a problem it would be best to index all attributes.

You can define as many attributes as you like, separated by commas.

This command has the following format:

set cache-index-all-except = attribute-list;