aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorfiaxh <git@lightrise.org>2020-11-05 17:09:15 +0100
committerfiaxh <git@lightrise.org>2020-11-05 17:11:46 +0100
commit1999c97bb925d64cfe7cbc230959ce9a18728081 (patch)
tree44f91f6d2adf4e298e8d0913036cf901d14b180a
parent6218b759bff5c865cf87d5579822781def1f243a (diff)
downloaddino-1999c97bb925d64cfe7cbc230959ce9a18728081.tar.gz
dino-1999c97bb925d64cfe7cbc230959ce9a18728081.zip
Improve content_item db table index
fixes #923 Co-authored-by: eta <eta@theta.eu.org>
-rw-r--r--libdino/src/service/database.vala12
1 files changed, 10 insertions, 2 deletions
diff --git a/libdino/src/service/database.vala b/libdino/src/service/database.vala
index 6384fa78..40967025 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 = 16;
+ private const int VERSION = 17;
public class AccountTable : Table {
public Column<int> id = new Column.Integer("id") { primary_key = true, auto_increment = true };
@@ -62,7 +62,7 @@ public class Database : Qlite.Database {
internal ContentItemTable(Database db) {
base(db, "content_item");
init({id, conversation_id, time, local_time, content_type, foreign_id, hide});
- index("contentitem_localtime_counterpart_idx", {local_time, conversation_id});
+ index("contentitem_conversation_hide_localtime_time_idx", {conversation_id, hide, local_time, time});
unique({content_type, foreign_id}, "IGNORE");
}
}
@@ -390,6 +390,14 @@ public class Database : Qlite.Database {
error("Failed to upgrade to database version 16: %s", e.message);
}
}
+ if (oldVersion < 17) {
+ try {
+ exec("DROP INDEX contentitem_localtime_counterpart_idx");
+ exec("CREATE INDEX contentitem_conversation_hide_localtime_time_idx ON content_item (conversation_id, hide, local_time, time)");
+ } catch (Error e) {
+ error("Failed to upgrade to database version 17: %s", e.message);
+ }
+ }
}
public ArrayList<Account> get_accounts() {