topic Pagination total count and performance issues in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/pagination-total-count-and-performance-issues/m-p/252249#M205379 <HTML><HEAD></HEAD><BODY><SPAN>Hi All,</SPAN><BR /><BR /><SPAN>I have implemented server side pagination for one of my requirements in alfresco share. In which I am doing below things in a JS based webscript.</SPAN><BR /><SPAN>1. Fire a lucene query and get the total count of records from the result received</SPAN><BR /><SPAN>2. Perform the same query giving paging objects and prepare JSON response of resulted records.</SPAN><BR /><BR /><SPAN>I have observed that - getting the records count in step-1 above is taking a long time. Hence, the performance is degraded. I have around 15000+ records and it may get extended to more than it.</SPAN><BR /><SPAN>I checked giving the hard-coded value for total count and then performance of the pagination is really good.</SPAN><BR /><BR /><SPAN>Could anyone please help me how can I get the count of records using lucene and get the good performance.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN></BODY></HTML> Tue, 17 Jan 2012 16:24:07 GMT romschn 2012-01-17T16:24:07Z Pagination total count and performance issues https://connect.hyland.com/t5/alfresco-archive/pagination-total-count-and-performance-issues/m-p/252249#M205379 Hi All,I have implemented server side pagination for one of my requirements in alfresco share. In which I am doing below things in a JS based webscript.1. Fire a lucene query and get the total count of records from the result received2. Perform the same query giving paging objects and prepare JSON r Tue, 17 Jan 2012 16:24:07 GMT https://connect.hyland.com/t5/alfresco-archive/pagination-total-count-and-performance-issues/m-p/252249#M205379 romschn 2012-01-17T16:24:07Z Re: Pagination total count and performance issues https://connect.hyland.com/t5/alfresco-archive/pagination-total-count-and-performance-issues/m-p/252250#M205380 <HTML><HEAD></HEAD><BODY><SPAN>The latest versions of alfresco have paging APIs.&nbsp;&nbsp; Its not easily solved on older code.</SPAN></BODY></HTML> Tue, 17 Jan 2012 17:41:09 GMT https://connect.hyland.com/t5/alfresco-archive/pagination-total-count-and-performance-issues/m-p/252250#M205380 mrogers 2012-01-17T17:41:09Z Re: Pagination total count and performance issues https://connect.hyland.com/t5/alfresco-archive/pagination-total-count-and-performance-issues/m-p/252251#M205381 <HTML><HEAD></HEAD><BODY><SPAN>I am using Alfresco v 3.4.3. Could you please provide me the direction to achieve the good performance for getting the total count of records. If this is solved, then there is no other issue for me.</SPAN><BR /><BR /><SPAN>Looking forward to your answer.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN></BODY></HTML> Wed, 18 Jan 2012 04:43:23 GMT https://connect.hyland.com/t5/alfresco-archive/pagination-total-count-and-performance-issues/m-p/252251#M205381 romschn 2012-01-18T04:43:23Z