Rev 501: Add indexes - thanks to spiv for pointing out. in file:///data/jelmer/bzr-svn/0.4/

[Jelmer Vernooij]

At file:///data/jelmer/bzr-svn/0.4/

------------------------------------------------------------
revno: 501
revision-id: jelmer at samba.org-20070626200724-b0mt1hsm0lj0gqf4
parent: jelmer at samba.org-20070626194359-bfkp1u7dcze8dnh1
committer: Jelmer Vernooij <jelmer at samba.org>
branch nick: main
timestamp: Tue 2007-06-26 22:07:24 +0200
message:
  Add indexes - thanks to spiv for pointing out.
modified:
  AUTHORS                        AUTHORS-20060508114718-4c90c0062645106d
  logwalker.py                   logwalker.py-20060621215743-c13fhfnyzh1xzwh2-1
  revids.py                      revids.py-20070416220458-36vfa0730cchevp1-1
=== modified file 'AUTHORS'
--- a/AUTHORS	2007-05-19 00:12:08 +0000
+++ b/AUTHORS	2007-06-26 20:07:24 +0000
@@ -1,8 +1,8 @@
 Jelmer Vernooij <jelmer at samba.org>
 
-Thanks to David Allouche, Erik Bågfors, Aaron Bentley, Max Bowser, 
-Jerry Carter, Robert Collins, Wouter van Heyst, Michael Hudson, David James, 
-Matthias Klose, John Arbash Meinel, Stefan Metzmacher, Andrew Mitchell, 
-Martin Pool, Garrett Rooney, Johan Rydberg, Peter Samuelson,
+Thanks to David Allouche, Erik Bågfors, Andrew Bennetts, Aaron Bentley, 
+Max Bowser, Jerry Carter, Robert Collins, Wouter van Heyst, Michael Hudson, 
+David James, Matthias Klose, John Arbash Meinel, Stefan Metzmacher, 
+Andrew Mitchell, Martin Pool, Garrett Rooney, Johan Rydberg, Peter Samuelson,
 Mark Shuttleworth and Reinhard Tartler for comments, code reviews, funding, 
 committing patches/bundles and generally keeping up while I was asking annoying questions.

=== modified file 'logwalker.py'
--- a/logwalker.py	2007-05-20 21:32:33 +0000
+++ b/logwalker.py	2007-06-26 20:07:24 +0000
@@ -80,6 +80,7 @@
           create table if not exists changed_path(rev integer, action text, path text, copyfrom_path text, copyfrom_rev integer);
           create index if not exists path_rev on changed_path(rev);
           create index if not exists path_rev_path on changed_path(rev, path);
+          create index if not exists path_rev_path_action on changed_path(rev, path, action);
         """)
         self.db.commit()
         self.saved_revnum = self.db.execute("SELECT MAX(revno) FROM revision").fetchone()[0]

=== modified file 'revids.py'
--- a/revids.py	2007-06-24 14:08:49 +0000
+++ b/revids.py	2007-06-26 20:07:24 +0000
@@ -90,8 +90,10 @@
         self.cachedb.executescript("""
         create table if not exists revmap (revid text, path text, min_revnum integer, max_revnum integer, scheme text);
         create index if not exists revid on revmap (revid);
+        create unique index if not exists revid on revmap (revid);
+        create index if not exists lookup_branch_revnum on revmap (max_revnum, min_revnum, path, scheme);
         create table if not exists revno_cache (revid text, dist_to_origin integer);
-        create unique index if not exists revid on revmap (revid);
+        create index if not exists revid on revno_cache (revid);
         """)
         self.cachedb.commit()