Hello
We have in our environment AEM6.0 SP3 and Oak 1.0.28
(cq-6.0.0-hotfix-9456)
The size of our repository ~80 GB and the Lucence index MB.
We are faced with the problem that the search through Content Finder or with QueryBuilder performed for a long time. Also when we limit path to a folder with several assets, search can takes from 90 sec to 120sec. Search via content finder by "test" keyword takes took 30-60 sec.
We added a debug configuration for analysis the query:
org.apache.jackrabbit.oak.jcr.query
org.apache.jackrabbit.oak.query
org.apache.jackrabbit.commons.query.GQL
org.apache.jackrabbit.oak.plugins.index
08.07.2016 09:30:43.158 *DEBUG* [127.0.0.1 [1467963038439] GET /content/aew/de/system/suche.html HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.lucene.LuceneIndex ... took 16 ms
08.07.2016 09:30:43.517 *DEBUG* [127.0.0.1 [1467963038439] GET /content/aew/de/system/suche.html HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.lucene.LuceneIndex loading the next 800 entries for query :fulltext:strom*
08.07.2016 09:30:43.517 *DEBUG* [127.0.0.1 [1467963038439] GET /content/aew/de/system/suche.html HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.lucene.LuceneIndex ... took 0 ms
08.07.2016 09:30:44.080 *DEBUG* [127.0.0.1 [1467963038439] GET /content/aew/de/system/suche.html HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.lucene.LuceneIndex loading the next 1600 entries for query :fulltext:strom*
08.07.2016 09:30:44.095 *DEBUG* [127.0.0.1 [1467963038439] GET /content/aew/de/system/suche.html HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.lucene.LuceneIndex ... took 15 ms
But when we have an look with the tool “explain Query” we can see, that it need long time for result count time:
"heuristics": {
"executeTime": 16,
"getNodesTime": 156,
"count": 190,
"countTime": 2000,
"totalTime": 217,
}
When the search request no result provided, the search is very fast
Can anyone give us a hint what could be the cause for the slow search?.
Thanks and best reagrds
Marc
