AnsweredAssumed Answered

TMQ, indexes and performances

Question asked by vincent-kali on Jun 21, 2017
Latest reply on Jun 26, 2017 by afaust

Hi all,

I'm working with TMQ on a large repo (about 5 millions of docs) on a community 5.1.g.

A read in doc that optional indexes could be added by the patch (http://dev.alfresco.com/resource/AlfrescoOne/5.0/configuration/alfresco/dbscripts/upgrade/4.2/org.hibernate.dialect.Dialect/metadata-query-indexes.sql)

But I checked that these indexes are already added in my DB. Does it means that this patch applies to previous versions only ?

 

In some situations, eventual queries are incomparably more performant that TMQ.

(about 1000x faster in some situations). Does it make sense ? Or it means that my postgres has to be tuned ?

 

Thanks,

Vincent

Outcomes