From: Mark Wooding <mdw@distorted.org.uk>
Date: Sat, 4 Jul 2015 17:02:40 +0000 (+0100)
Subject: sql/setup-shorturl.sql: Add index by (url, owner).
X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~mdw/git/odin-cgi/commitdiff_plain/bdae614e352884df1a95311bd669d6b918c6b7a2

sql/setup-shorturl.sql: Add index by (url, owner).

When we're trying to create a new entry, we search for an existing entry
for the same URL and a similar owner.  The index means we avoid having
to do a full scan of the table for this.
---

diff --git a/sql/setup-shorturl.sql b/sql/setup-shorturl.sql
index 3b20463..eaddf90 100644
--- a/sql/setup-shorturl.sql
+++ b/sql/setup-shorturl.sql
@@ -21,5 +21,6 @@ create table odin_shorturl
 	 owner varchar(64) not null,
 	 url text not null);
 create index odin_shorturl_by_owner on odin_shorturl (owner);
+create index odin_shorturl_by_url_owner on odin_shorturl (url, owner);
 
 commit;