topic Re: Lucene path query in Alfresco Archive

Lucene path query

mhb — Tue, 04 Oct 2016 15:58:25 GMT

I'm trying to find a way to improve lucene path query performance, this kind of queries is too slow. Do you have any issues?

Re: Lucene path query

afaust — Tue, 04 Oct 2016 17:52:02 GMT

Which Alfresco version are you currently using? Are you using SOLR1, 4 or still embedded Lucene?

PATH queries have always been inefficient. If possible, change to property-based lookups / queries. Try to minimize wildcards within the path.

Generally, try not to use Lucene queries - instead use FTS queries. FTS queries are more optimized and if they are simple enough (not using PATH and some other features) they can actually be executed against the database instead of the index.

Re: Lucene path query

mhb — Wed, 05 Oct 2016 05:36:15 GMT

I'm using alfresco 4.2.c, embedded Lucene

Re: Lucene path query

kaynezhang — Wed, 05 Oct 2016 13:37:01 GMT

Why not upgrade your alfresco and use Solr,Solr has better performence and can scale Alfresco even larger than Lucene.

I think moving from an embedded Lucene search engine to the stand-alone Solr engine is the right way to improve performance.

As data grows embedded Lucene engine's “in transaction” indexing and permission evaluation after query will runs slower and slower.