From 2c717d347d796a2b007331c42d78146e156eaea0 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?louiz=E2=80=99?= <louiz@louiz.org>
Date: Sat, 26 Aug 2017 17:40:54 +0200
Subject: Add an index for the muc_log_line table

This immensely speeds up the archive select queries.

fix #3292
---
 src/database/database.cpp | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'src/database/database.cpp')

diff --git a/src/database/database.cpp b/src/database/database.cpp
index 0f2349d..f706528 100644
--- a/src/database/database.cpp
+++ b/src/database/database.cpp
@@ -6,6 +6,8 @@
 #include <utils/get_first_non_empty.hpp>
 #include <utils/time.hpp>
 
+#include <database/index.hpp>
+
 #include <sqlite3.h>
 
 sqlite3* Database::db;
@@ -42,6 +44,7 @@ void Database::open(const std::string& filename)
   Database::irc_channel_options.upgrade(Database::db);
   Database::roster.create(Database::db);
   Database::roster.upgrade(Database::db);
+  create_index<Database::Owner, Database::IrcChanName, Database::IrcServerName>(Database::db, "archive_index", Database::muc_log_lines.get_name());
 }
 
 
-- 
cgit v1.2.3