Rev 881: Fix performance regression in sqlite queries. Thanks, spiv, for helping track this down. in file:///data/jelmer/bzr-svn/0.4.8/

[Jelmer Vernooij]

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

------------------------------------------------------------
revno: 881
revision-id:jelmer at samba.org-20080311170536-rs1n7ekg4tc3il2u
parent: jelmer at samba.org-20080311170221-h15rck3wq79ivm67
committer: Jelmer Vernooij <jelmer at samba.org>
branch nick: 0.4.8
timestamp: Tue 2008-03-11 18:05:36 +0100
message:
  Fix performance regression in sqlite queries. Thanks, spiv, for helping track this down.
modified:
  NEWS                           news-20061231030336-h9fhq245ie0de8bs-1
  revids.py                      revids.py-20070416220458-36vfa0730cchevp1-1
=== modified file 'NEWS'
--- a/NEWS	2008-03-11 17:02:21 +0000
+++ b/NEWS	2008-03-11 17:05:36 +0000
@@ -8,6 +8,8 @@
 
    * Add progress bar to fetch initialization code. 
 
+   * Fix performance regression in sqlite queries.
+
 bzr-svn 0.4.7	2008-02-01
  
   FEATURES

=== modified file 'revids.py'
--- a/revids.py	2008-01-28 22:52:09 +0000
+++ b/revids.py	2008-03-11 17:05:36 +0000
@@ -91,7 +91,7 @@
         assert isinstance(path, str)
         assert isinstance(scheme, str)
         revid = self.cachedb.execute(
-                "select revid from revmap where max_revnum = min_revnum and min_revnum='%s' and path='%s' and scheme='%s'" % (revnum, path, scheme)).fetchone()
+                "select revid from revmap where max_revnum = '%s' and min_revnum='%s' and path='%s' and scheme='%s'" % (revnum, revnum, path, scheme)).fetchone()
         if revid is not None:
             return str(revid[0])
         return None