libQuotient spending a lot of time in sqlite call

[EbonJaeger]

Describe the bug
For a week or two now, I've been noticing NeoChat freezing for a couple of seconds whenever I sent a message in a room. After some debugging in the NeoChat Matrix room, I generated a perf log and flame graph with hotspot, which indicated that libQuotient was spending a lot of time on Quotient::_impl::ConnectionEncryptionData::saveDevicesList() (libQuotientQt6.so.0.9.3), which then went into sqlite3. On inspecting the size of my caches, we determined that they are larger than expected, but didn't seem excessively large. They recommended that I create an issue here for further debugging.

To Reproduce
Steps to reproduce the behavior, and the description of the actual result:

1. Open NeoChat
2. Navigate to a room
3. Type and send a message
4. Try to do any interaction with NeoChat

Expected behavior
NeoChat should continue to be responsive; i.e., room navigation should still work, and I should be able to start typing another message.

Is it environment-specific?

• OS: Solus 4.7
• Version of the library: 0.9.3
• Linkage: dynamic

Additional context

perf output files:
neochat_perf.zip

[KitsuneRal]

Sorry for taking time to respond. The code that includes saveDevicesList() is actually on its way out - we're going to replace it with the encryption backend built on matrix-rust-sdk-crypto Rust crate - follow #820 if you want to learn when it lands. Hopefully this will give better performance and this particular bottleneck won't be there.

[EbonJaeger]

Ah, sweet! I will wait patiently, then.