topic CMIS: Poor performance with 1M documents in Nuxeo Forum

CMIS: Poor performance with 1M documents

JVent_ — Thu, 12 Nov 2015 15:46:15 GMT

Hi, we are testing Nuxeo 6.0 in order to know the performance with high number of documents. We are using a cluster with 2 nuxeo nodes and two elasticsearch nodes (4 machines in total). The performence with Nuxeo is stabble, but CMIS hangs constantly. It costs 2 minutes to create a single document or 30 seconds to get the root folder.

The database that we are consuming the information is Oracle.

CMIS worked great with a 10K documents, but with 1 million, it completily hangs.

Is there any optimization to make CMIS work?

Thanks

Re: CMIS: Poor performance with 1M documents

ben_ — Thu, 12 Nov 2015 16:41:35 GMT

Hi, There are certainly some tuning to do on the database/schema/application side, you can also run your CMIS search on Elasticsearch instead of the database using the following option in nuxeo.conf: org.nuxeo.cmis.elasticsearch=true

Regards ben

Re: CMIS: Poor performance with 1M documents

bruce_Grant — Fri, 13 Nov 2015 13:09:02 GMT

My experience with CMIS on Nuxeo (and Alfresco for that matter) is not good - especially with large numbers of documents and searches that may yield many results. One repository I'm working on has close to 80 million documents and although normalized CMIS access would have been great it just didn't have the required performance.

Re: CMIS: Poor performance with 1M documents

Florent_Guillau — Sat, 14 Nov 2015 18:03:40 GMT

> It costs 2 minutes to create a single document or 30 seconds to get the root folder

Re: CMIS: Poor performance with 1M documents

JVent_ — Mon, 16 Nov 2015 17:54:14 GMT

this option is only available since 7.2 and we are using Nuxeo 6.0

Re: CMIS: Poor performance with 1M documents

ben_ — Tue, 17 Nov 2015 13:34:50 GMT

https