Check performance of message retrieval stored procedures for MySQL (#84)

Activities

Andrzej Wójcik (Tigase) opened 6 days ago

Fetching messages still causes timeouts on our installation when a lot of data to be retrieved. It would be good to review their performance and usage of indexes.

Andrzej Wójcik (Tigase) changed state to 'In Progress' 6 days ago

Previous Value	Current Value
Open	In Progress

Andrzej Wójcik (Tigase) added "Related" tigase-private/systems-maintenance/servers#384 6 days ago

Andrzej Wójcik (Tigase) commented 6 days ago

I've reviewed stored procedures and their SQL queries and I've found a suboptimal usage of indexes in one of the cases. I've modified source code of the stored procedures and committed them in a separate branch named issue-84. Those changes still need to be tested but initial tests confirmed that they improve performance of the data retrieval.

Referenced from commit 6 days ago

Improved performance of SQL queries to fetch MAM data #84

Andrzej Wójcik (Tigase) committed 6 days ago