From a2857a13c66bef5f601bdb89df7da1bc9756315d Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Mon, 29 Sep 2014 14:19:36 +0000 Subject: [PATCH] database: Add an index on the hostname column --- src/ddns/database.py | 2 ++ 1 file changed, 2 insertions(+) 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")) -- 2.39.2