CMIS Querying with Path having performance issues

[gluck113]

Hello Alfresco Community, 

I'm starting a new Alfresco project and we are doing some tests linking Alfresco with a C-Sharp Application through CMIS. We have a encountered a minor setback while querying with PATHs.

I'll explain: when we execute this query without a Path we have an immediate answer:

ses.Query("select * from cerocType where cer:statid = 414", false);

but when doing it like this it takes 2-3 seconds for an answer:

ses.Query("select * from cerocType where cer:statid = 414 " + " and contains('PATH:\"/app:company_home/st:sites/cm:test/cm:documentLibrary/cmtaoDoku/cm:Test//*\"')", false);

Has anybody encountered this issue? Could it be a configuration issue? We installed 5.2 out of the box...

I see a hacky way out but I want to be sure before going down that road...

[gluck113 · Accepted solution]

After discussion with Axel Faust‌ it seems the Path is not indexed in Solr as quickly as the metadata properties which are stored in the DB.

We must tune our Solr or put the Path in a metadata property (the hacky solution)