Treeview loading slow when the collection more than 1000

[Di]

I recently upgraded to v2.7.1, and I've noticed that the treeview loads slowly when the collection has a large number of items, for example, when there are 4500+ items in the collection. This issue was not present in the earlier version.

I have tried the following troubleshooting steps:
1. Rebuilding the Nested Set.
2. Rebuilding the search index and clearing the cache.

However, these actions did not resolve the issue.

Thanks

Di

[Di]

But if the colletion is in short items, even there are 2 or 3 sub-levels, no such performance issue.   

[Dan Gillean]

Hi Di, 

A few initial questions: 

• What was the previous version you were running?
• What is the value you have set in the Items Per Page setting for the full-width treeview?
• Does your installation meet or surpass the recommended hardware minimums?

Processor: 2 vCPUs @ 2.3GHz
Memory: 7GB
Disk space (processing): 50GB at a minimum for AtoM’s core stack plus more storage would be required for supporting any substantial number of digital objects.

See: https://www.accesstomemory.org/en/docs/2.7/admin-manual/installation/requirements/#minimum-hardware-requirements

There are some known issues we have been attempting to address across multiple releases with the full-width treeview's behavior on large hierarchies. If you'd like to read about some of the history and known issues prior to the most recent version, there is a PDF attached to this legacy issue ticket with more context: 

• https://projects.artefactual.com/issues/13293
  

Note that neither of the proposed solutions in that document have been implemented - though rather than adding a setting to disable paging in the treeview (originally added to help with performance, so the site is not trying to fetch and load thousands and thousands of records at once), we instead did some testing and now allow the Items Per Page setting to be set as high as 10,000 instead. If you have more than 10,000 direct child recodds from a parent top-level record, honestly it will help your site to page after that anyway, as attempting to load any more would definitely impact performance. 

In any case, I will make the Maintainers aware of this thread so they can track these kinds of reports and potentially investigate further. In the meantime, let me know about those initial questions and we can go from there. 

Cheers, 

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

he / him

--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/70e22d70-b2d7-4ae7-8105-29d16c81868dn%40googlegroups.com.

[Di]

Hi Dan, thanks for the reply. 

Regards to the initial questions. 

• What was the previous version you were running?   ----- Previous Version is Atom 2.6.4 / Ubuntu 18.04 / RAM 8GB, 2vCPU 
• What is the value you have set in the Items Per Page setting for the full-width treeview?  --- 10000 items per page , Full Width (identifier -- Yes --- No)
• Does your installation meet or surpass the recommended hardware minimums?  New environment: 2vCPU, 8GB and 100GB Harddisk (24% Used), / Ubuntu 20.04.6 LTS, even I tested on an 8vCPU and 32GB cloud hosting, still same issue.

These 4500+ items locate under Level 2 folder. 

Thanks,

Di

[Dan Gillean]

Thanks for sharing these details! 

I will pass this information on to our Maintainers, so they can track this report for themselves and determine next steps.

Cheers, 

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

he / him

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/579d8f6d-7195-40fb-bf2b-14a389f36527n%40googlegroups.com.