-
Type:
Improvement
-
Status: Resolved
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 5.3 GA
-
Fix Version/s: None
-
Component/s: Core VCS
-
Tags:
The NXQL startswith operator uses either a descendants table if populated either a stored procedure named NX_IN_TREE.
The number of rows in the descendants table is around max depth * nb documents, there are 3 indexes on this table.
This makes the table enormous when having millions of documents.
The NX_IN_TREE has a constant cost per filtered row (like 1s for 1000 rows) and don't scale with query that return more than thousands docs.
When having millions of documents the startswith operator can be desactivated by adding a single line in the descendants table.
