database: Add an index on the hostname column

[people/stevee/ddns.git] / src / ddns / database.py

diff --git a/src/ddns/database.py b/src/ddns/database.py
index 1e613c914c2cdbeda1a27935f8a7dc68eacee8ea..5d4ffc98ff85372fda120bb84845c230b83484e8 100644 (file)
--- a/src/ddns/database.py
+++ b/src/ddns/database.py
@@ -61,6 +61,8 @@ class DDNSDatabase(object):
                                        k TEXT NOT NULL,
                                        v TEXT NOT NULL
                                );
+
+                               CREATE INDEX idx_updates_hostname ON updates(hostname);
                        """)
                        c.execute("INSERT INTO settings(k, v) VALUES(?, ?)", ("version", "1"))