From 3769d06940e6cf68f0f9ecafb4c275cf33944ea2 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/src') diff --git a/libdino/src/service/database.vala b/libdino/src/service/database.vala index 25a6b477..7cb015e2 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 = 23; + 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