Performance regression on document deletion under Oracle
--------------------------------------------------------
Key: NXP-8668
URL: https://jira.nuxeo.com/browse/NXP-8668
Project: Nuxeo Enterprise Platform
Issue Type: Bug
Components: Core SQL Storage
Environment: oracle 10g
Reporter: Benoit Delbosc
Problem reported on answers by Romain France
"""
We can't delete document since we've upgrade nuxeo 5.4.2 to 5.5 (DataBase
Oracle 10G). It doesn't work anymore with Nuxeo GUI, API Java or REST API.
It seems that this request (operated bi Nuxeo) is very slow :
{code}
SELECT "HIERARCHY"."ID", "HIERARCHY"."PARENTID", "HIERARCHY"."PRIMARYTYPE",
"HIERARCHY"."ISPROPERTY", "PROXIES"."VERSIONABLEID", "PROXIES"."TARGETID" FROM
"HIERARCHY" LEFT JOIN "PROXIES" ON "HIERARCHY"."ID" = "PROXIES"."ID" WHERE
EXISTS(SELECT :"SYS_B_0" FROM ancestors WHERE hierarchy_id = "HIERARCHY"."ID"
AND :1 MEMBER OF ancestors)
{code}
"""
--
This message is automatically generated by JIRA.
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
