topic Alfresco lucene query performance in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-lucene-query-performance/m-p/298305#M251435 <HTML><HEAD></HEAD><BODY><SPAN>Hi All,</SPAN><BR /><BR /><SPAN>We are having document listing page which fetches the documents with page size of 25/100/500. (Total around 32K documents)</SPAN><BR /><BR /><SPAN>This takes long time to fetch the documents and we are trying to optimize the mysql.</SPAN><BR /><BR /><SPAN>We have only one custom table which is used to store and fetch the count.</SPAN><BR /><BR /><SPAN>We got the below log from mysql.</SPAN><BR /><BR /><SPAN>- Slow Queries: 1.25</SPAN><BR /><SPAN>- Number of Joins that need an index in the last 24hours:1476.1370</SPAN><BR /><BR /><SPAN>Is this looks Ok OR we need to do anything with this?</SPAN><BR /><BR /><SPAN>How can we improve performance and decrease the time?</SPAN></BODY></HTML> Wed, 14 May 2014 06:58:24 GMT aaditvmajmudar 2014-05-14T06:58:24Z Alfresco lucene query performance https://connect.hyland.com/t5/alfresco-archive/alfresco-lucene-query-performance/m-p/298305#M251435 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 bel Wed, 14 May 2014 06:58:24 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-lucene-query-performance/m-p/298305#M251435 aaditvmajmudar 2014-05-14T06:58:24Z Re: Alfresco lucene query performance https://connect.hyland.com/t5/alfresco-archive/alfresco-lucene-query-performance/m-p/298306#M251436 <HTML><HEAD></HEAD><BODY><SPAN>In embedded Lucene permissions are checked after lucene returned all results,That means if you want to search with page size 500,luene will search more that 500(default is 1000) doucuments and starts to check the permissions one by one. So the larger the page size you set ,the slower it will get.</SPAN><BR /><SPAN>You should consider upgrading to Alfresco 4 and use Solr,in solr permissions are checked at query time ,it has better performance.</SPAN></BODY></HTML> Wed, 14 May 2014 12:07:01 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-lucene-query-performance/m-p/298306#M251436 kaynezhang 2014-05-14T12:07:01Z Re: Alfresco lucene query performance https://connect.hyland.com/t5/alfresco-archive/alfresco-lucene-query-performance/m-p/298307#M251437 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for your answer.</SPAN><BR /><BR /><SPAN>At this stage, we have identified that the sorting on "modified date" takes around "15-20sec" for around 30K contents.</SPAN><BR /><BR /><SPAN>Other than "modified date" property, all other properties like name, created date and custom&nbsp; properties takes around "4 sec" for sorting.</SPAN><BR /><BR /><SPAN>What can be the root cause for this issue that only "modified date" sorting takes much long time to return the results?</SPAN><BR /><BR /><SPAN>How to resolve this problem? </SPAN><BR /><BR /></BODY></HTML> Thu, 05 Jun 2014 07:27:22 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-lucene-query-performance/m-p/298307#M251437 aaditvmajmudar 2014-06-05T07:27:22Z Re: Alfresco lucene query performance https://connect.hyland.com/t5/alfresco-archive/alfresco-lucene-query-performance/m-p/298308#M251438 <HTML><HEAD></HEAD><BODY><SPAN>Have you ever configured "modified date" to use a different lucene analyzer.as I remember by default "created date" and "modified date" are configured to use same DateAnalyer in alfresco 3.4,so sorting by them should take nearly same time. </SPAN><BR /></BODY></HTML> Thu, 05 Jun 2014 14:13:15 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-lucene-query-performance/m-p/298308#M251438 kaynezhang 2014-06-05T14:13:15Z Re: Alfresco lucene query performance https://connect.hyland.com/t5/alfresco-archive/alfresco-lucene-query-performance/m-p/298309#M251439 <HTML><HEAD></HEAD><BODY><SPAN>No, we have not configured any different lucene analyzer.</SPAN><BR /><BR /><SPAN>But sorting with created date is not taking much time as modified date.</SPAN><BR /><BR /><SPAN>Sorting with created date takes around 4-5 sec only.</SPAN></BODY></HTML> Thu, 05 Jun 2014 15:26:09 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-lucene-query-performance/m-p/298309#M251439 aaditvmajmudar 2014-06-05T15:26:09Z