Lucene path query

[mhb]

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?

[afaust]

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.

[mhb]

I'm using alfresco 4.2.c, embedded Lucene

[kaynezhang]

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.