[
https://jira.nuxeo.com/browse/NXP-4994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benoit Delbosc updated NXP-4994:
--------------------------------
Fix Version/s: (was: 5.4.x)
Security: (was: Internal)
Tags: performances (was: fix53x)
> Make NXQL ecm:path STARTSWITH operator more scalable
> ----------------------------------------------------
>
> Key: NXP-4994
> URL: https://jira.nuxeo.com/browse/NXP-4994
> Project: Nuxeo Enterprise Platform
> Issue Type: Improvement
> Components: Core SQL Storage
> Affects Versions: 5.3 GA
> Reporter: Benoit Delbosc
> Assignee: Benoit Delbosc
>
> 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
