Performance and resource use

DQL processing consumes memory, disk, and CPU resources. To preserve those resources and to speed up query processing, optimize your queries as much as possible.

In this release, there are two ways to service query terms in DQL:
  • NSF data scans
  • View entry scans
In general, in general, view entries are more efficient to use, though that can vary by view construction and size of results. Equality searches that find a small or medium number of documents are particularly faster using views. So, it becomes important to know how the DQL engine optimizes access to use full text indexes and views.

DQL processing functions very well in the mix of operational traffic on a Domino® server but it is not free in that aspect either. Read-only view access increases as does NSF summary data access. That processing is nothing new to the server, but its effect should be studied to avoid any regression in related processing.

To use the index of a view or folder, that index must have some special properties.