search

gawati / gawati-portal-ui

Version 2 of the gawati portal
GNU Affero General Public License v3.0
0 stars 0 forks source link

Performance: Home page recent documents listing degrades with volume #38

Closed kohsah closed 6 years ago

kohsah commented 6 years ago

When the number of documents in the system increases, there is a significant degradation of the "Recent Documents" listing. This is not evident when the system has an optimal amount of memory, however during testing by allocating smaller amounts of RAM to the JVM, this problem became evident.

We need to apply sort-indexes to the data, to improve the efficiency of pure listing queries (where data is not filtered ) (see https://exist-db.org/exist/apps/fundocs/view.html?uri=http://exist-db.org/xquery/sort&location=java:org.exist.xquery.modules.sort.SortModule )

kohsah commented 6 years ago

NOTE: This problem seems specific to eXist 3.6.0 , attempt to deploy on eXist 4.0 and eXist 3.4.x for comparison

kohsah commented 6 years ago

See issue follow ups here: https://github.com/gawati/gawati-data/issues/11