topic Performance issue in listing content from repository in Alfresco Archive

Performance issue in listing content from repository

faizaan — Tue, 17 Apr 2012 11:18:56 GMT

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

Re: Performance issue in listing content from repository

wabson — Tue, 17 Apr 2012 18:52:06 GMT

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

Re: Performance issue in listing content from repository

faizaan — Wed, 18 Apr 2012 04:49:20 GMT

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&userName=admin&sort=articlePrintTitle&dir=asc&startIndex=0
&rowsPerPage=25
‍‍‍‍

Thanks,
Faizaan