Performance issue in listing content from repository

[faizaan]

Hi,

We are facing serious performance issue in listing content from repository to an alfresco share page.

We have around 1 lakh content spread across folders created according to following pattern :

             -Site Name
                           -Year
                                 - Month
                                          -Day 1
                                                  -Content1
                                                  -Content2
                                              .
                                              .
                                          -Day n
                                                  -Content1
                                                  -Content2

Number of contents inside each day folder may range from 3k to 8k.

We have created repository tire javascript api based webscript in which we fire recursive query (//*) on root folder with limit of 25 to fetch records.

But it is taking around 80 to 100 seconds for fetching and displaying just 25 records .


    -We have modified below properties in alfresco-global.properties
      
              - system.acl.maxPermissionCheckTimeMillis=200000
               -system.acl.maxPermissionChecks=100000

   -Environment Details
      
            -Alfresco 3.4.3
            -Mysql
            -Tomcat    
                     

Please suggest ways to overcome this performance issue 

Thanks

[wabson]

Can you post a copy of the complete web script? Also an example of the URL you are calling, which takes such a long amount of time to return, would be helpful.

Lastly I think this more related to web scripts than to Share Development, so unless you can think of a good reason why I shouldn't I will move this to the Web Scripts forum.

Cheers,
Will

[faizaan]

Thanks will,

Below is the code snippet of our webscript :

var skipCount=args["startIndex"];
var sortField=args["sort"];
var sortOrder=args["dir"];
var pageSize = args["rowsPerPage"];

var sortingOrder=true;
    
             if(sortOrder =="desc")
              {
                 sortingOrder=false;
              }

var sortInfo =
       {
             column: "@{prefix:customModel}articlePrintTitle",
             ascending: sortingOrder
       };


var query = "PATH:\"/app:company_home/st:sites/cm:" + sitename + "/cm:Article//*\" AND TYPE:\"prefix:article\"";

var paging =
     {
        maxItems: pageSize,
        skipCount:skipCount 
     };
    
var limitQuery =
     {
        query: query,
        store: "workspace://SpacesStore",
        language: "lucene",
        sort:[sortInfo],
        page: paging
     };

var result = search.query(limitQuery);

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

For executing search.query(limitQuery) it takes around 80 to 100 seconds

We are calling above web script from client side javascript via data source

Final url that is hit from client side js is as below :

http://localhost:8080/share/proxy/alfresco/repository/article?sitename=testSite&filterStatus=All&use...
&rowsPerPage=25
‍‍‍‍

Thanks,
Faizaan