Skip to content

Performance: Use Sort Indexes to Improve performance #11

@kohsah

Description

@kohsah

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 )

Current TTFB for listings with over 50,000 docs is 66 seconds .

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions