From: Michael Tremer <michael.tremer@ipfire.org>
Date: Mon, 29 Sep 2014 14:19:36 +0000 (+0000)
Subject: database: Add an index on the hostname column
X-Git-Tag: 005~2
X-Git-Url: http://git.ipfire.org/?p=oddments%2Fddns.git;a=commitdiff_plain;h=a2857a13c66bef5f601bdb89df7da1bc9756315d

database: Add an index on the hostname column
---

diff --git a/src/ddns/database.py b/src/ddns/database.py
index 1e613c9..5d4ffc9 100644
--- 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"))