nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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

Find more posts tagged with

Comments

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

Thanks,
Faizaan