[
http://jira.nuxeo.org/browse/NXP-3872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benoit Delbosc reassigned NXP-3872:
-----------------------------------
Assignee: Benoit Delbosc (was: Thierry Delprat)
> Default USER_WORKSPACES querymodel generates a very expensive query
> -------------------------------------------------------------------
>
> Key: NXP-3872
> URL: http://jira.nuxeo.org/browse/NXP-3872
> Project: Nuxeo Enterprise Platform
> Issue Type: Improvement
> Components: Search / Query
> Affects Versions: 5.2 GA
> Reporter: Benoit Delbosc
> Assignee: Benoit Delbosc
> Fix For: 5.2.1
>
> Original Estimate: 1 hour
> Remaining Estimate: 1 hour
>
> At the sql level the list of user's workspaces is
> SELECT DISTINCT _nxhier.id, dublincore.title
> FROM hierarchy _nxhier
> LEFT JOIN proxies ON proxies.id = _nxhier.id
> JOIN hierarchy ON (hierarchy.id = _nxhier.id OR hierarchy.id =
> proxies.targetid)
> LEFT JOIN dublincore ON hierarchy.id = dublincore.id
> LEFT JOIN misc ON hierarchy.id = misc.id
> WHERE
> hierarchy.primarytype IN ('Workspace')
> AND (misc.lifecyclestate <> 'deleted')
> AND (NOT (NX_IN_TREE(_nxhier.id, '7bdcedfe-3b42-4676-a823-c818396bef58')))
> AND NX_ACCESS_ALLOWED(_nxhier.id, '{members,user5,Everyone}',
>
> '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}')
> ORDER BY dublincore.title;
> The join on proxies is useless and very costly when there are many documents.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.nuxeo.org/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
