[
http://jira.nuxeo.org/browse/NXP-4061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume updated NXP-4061:
-----------------------------------
Description:
VCS searches involving proxies need to do a
LEFT JOIN proxies ON proxies.id = _nxhier.id
JOIN hierarchy ON (hierarchy.id = _nxhier.id OR hierarchy.id =
proxies.targetid)
and the OR part is very costly.
Find a way to change this, either by using a UNION ALL of two queries (one one
normal docs, the other on proxies), or something else.
was:
SQL searches involving proxies need to do a
LEFT JOIN proxies ON proxies.id = _nxhier.id
JOIN hierarchy ON (hierarchy.id = _nxhier.id OR hierarchy.id =
proxies.targetid)
and the OR part is very costly.
Find a way to change this, either by using a UNION ALL of two queries (one one
normal docs, the other on proxies), or something else.
> VCS: improve proxy-based search performance
> -------------------------------------------
>
> Key: NXP-4061
> URL: http://jira.nuxeo.org/browse/NXP-4061
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Core SQL Storage
> Affects Versions: 5.2 GA
> Reporter: Florent Guillaume
> Assignee: Florent Guillaume
> Priority: Critical
> Fix For: 5.2.1
>
> Original Estimate: 3 days
> Remaining Estimate: 3 days
>
> VCS searches involving proxies need to do a
> LEFT JOIN proxies ON proxies.id = _nxhier.id
> JOIN hierarchy ON (hierarchy.id = _nxhier.id OR hierarchy.id =
> proxies.targetid)
> and the OR part is very costly.
> Find a way to change this, either by using a UNION ALL of two queries (one
> one normal docs, the other on proxies), or something else.
--
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
