topic Re: Very slow nxql query with some filters in Nuxeo Forum

Very slow nxql query with some filters

Ahmad_BenMaallem — Wed, 27 Jan 2021 07:58:42 GMT

Hello,

I have a nuxeo with mongoDB which contains a lot of data.

My problem is that the following nxql query is very slow: select * from Document where ecm:isTrashed = 0

By removing the filter on ecm:isTrashed, I will have an immediate response, That's why I thought about adding an index for ecm: isTrashed in mongodb but the problem still persists.

For your information, while consulting my documents with mongoDB compass, I noticed that ecm: isTrashed does not appear in the json of my documents and it will be added only for the documents which are in the trash, maybe it is therefore, creating an index does not solve the problem.

Do you have an idea please

Re: Very slow nxql query with some filters

Gregory_Carlin — Mon, 01 Feb 2021 20:48:16 GMT

What about the Elasticsearch indexes and nodes?

Re: Very slow nxql query with some filters

Ahmad_BenMaallem — Tue, 02 Feb 2021 07:40:01 GMT

The Elasticsearch indexes and nodes are properly configured and initialized.

Re: Very slow nxql query with some filters

Gregory_Carlin — Tue, 02 Feb 2021 09:13:47 GMT

NXQL page provider is using the DB implementation

Re: Very slow nxql query with some filters

Ahmad_BenMaallem — Tue, 02 Feb 2021 10:04:46 GMT

Are you saying I need to add "nxql_search" to the "elasticsearch.override.pageproviders" property in nuxeo.conf ?