[
https://jira.nuxeo.com/browse/NXP-8668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benjamin Jalon updated NXP-8668:
--------------------------------
Domain: [Content Repository, Perf]
> 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
