From 4e1311dfa9944fc04089037783db6a0a6eef7345 Mon Sep 17 00:00:00 2001 From: Marvin W Date: Mon, 20 Mar 2023 15:40:44 -0600 Subject: Improve database performance while reconnecting and syncing Also move some tasks to low priority idle queue so they won't block UI updates --- libdino/src/service/database.vala | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'libdino') diff --git a/libdino/src/service/database.vala b/libdino/src/service/database.vala index 96b3b82d..6b3f5e6a 100644 --- a/libdino/src/service/database.vala +++ b/libdino/src/service/database.vala @@ -7,7 +7,7 @@ using Dino.Entities; namespace Dino { public class Database : Qlite.Database { - private const int VERSION = 25; + private const int VERSION = 26; public class AccountTable : Table { public Column id = new Column.Integer("id") { primary_key = true, auto_increment = true }; @@ -93,6 +93,11 @@ public class Database : Qlite.Database { // deduplication index("message_account_counterpart_stanzaid_idx", {account_id, counterpart_id, stanza_id}); + index("message_account_counterpart_serverid_idx", {account_id, counterpart_id, server_id}); + + // message by marked + index("message_account_marked_idx", {account_id, marked}); + fts({body}); } } -- cgit v1.2.3-70-g09d2