01-26-2021 11:58 PM
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
02-01-2021 12:48 PM
What about the Elasticsearch indexes and nodes?
02-01-2021 11:40 PM
The Elasticsearch indexes and nodes are properly configured and initialized.
02-02-2021 01:13 AM
NXQL page provider is using the DB implementation
02-02-2021 02:04 AM
Are you saying I need to add "nxql_search" to the "elasticsearch.override.pageproviders" property in nuxeo.conf ?
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.