AnsweredAssumed Answered

Alfresco lucene query performance

Question asked by aaditvmajmudar on May 14, 2014
Latest reply on Jun 5, 2014 by kaynezhang
Hi All,

We are having document listing page which fetches the documents with page size of 25/100/500. (Total around 32K documents)

This takes long time to fetch the documents and we are trying to optimize the mysql.

We have only one custom table which is used to store and fetch the count.

We got the below log from mysql.

- Slow Queries: 1.25
- Number of Joins that need an index in the last 24hours:1476.1370

Is this looks Ok OR we need to do anything with this?

How can we improve performance and decrease the time?