git » sdk » commit 2454e96

Need an index for sync point

author Stephen Paul Weber
2026-05-26 20:40:21 UTC
committer Stephen Paul Weber
2026-05-26 20:40:21 UTC
parent 91484027da93e9f284fb1b2ba63563a1028beddd

Need an index for sync point

borogove/persistence/Sqlite.hx +6 -0

diff --git a/borogove/persistence/Sqlite.hx b/borogove/persistence/Sqlite.hx
index 2dc14f6..f9bac0e 100644
--- a/borogove/persistence/Sqlite.hx
+++ b/borogove/persistence/Sqlite.hx
@@ -256,6 +256,12 @@ class Sqlite implements Persistence implements KeyValueStore {
 						"PRAGMA user_version = 11"]);
 					}
 					return Promise.resolve(null);
+				}).then(_ -> {
+					if (version < 12) {
+						return exec(["CREATE INDEX messages_sync_point ON messages (account_id, mam_by, sort_id DESC) WHERE sync_point",
+						"PRAGMA user_version = 12"]);
+					}
+					return Promise.resolve(null);
 				});
 			});
 		});