Improve MUC history load time for single rooms

Description

When loading a MUC room for the database, its history is obtained from the table ofMucConversationLog. This is rather slow on larger instances. This is very noticable on ignite’s server, where paging through the admin console takes a long, long time.

Environment

None

Activity

Show:

Guus der Kinderen October 12, 2022 at 6:57 AM

Two fixes:

  • add database index to speed up SELECT query

  • add content to history in bulk, to reduce acquiring/releasing of locks.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Priority

Created October 11, 2022 at 5:44 PM
Updated October 12, 2022 at 6:57 AM
Resolved October 12, 2022 at 6:57 AM

Flag notifications