[tahoe-lafs-trac-stream] [tahoe-lafs] #1870: leasedb: performance regression

[tahoe-lafs]

#1870: leasedb: performance regression
-------------------------+-------------------------------------------------
     Reporter:           |      Owner:  daira
  davidsarah             |     Status:  new
         Type:  defect   |  Milestone:  1.11.0
     Priority:  normal   |    Version:  1.9.2
    Component:  code-    |   Keywords:  leasedb performance regression
  storage                |  sqlite
   Resolution:           |
Launchpad Bug:           |
-------------------------+-------------------------------------------------

Comment (by daira):

 Only the following queries are used in that test:
 {{{
 INSERT OR REPLACE INTO `leases` VALUES (?,?,?,?,?)
 INSERT OR REPLACE INTO `shares` VALUES (?,?,?,?,?,?,?)
 SELECT `storage_index`, `shnum` FROM `shares`
        WHERE `storage_index`=? AND `shnum`=?
 UPDATE `shares` SET `state`=?, `used_space`=?, `backend_key`=?
        WHERE `storage_index`=? AND `shnum`=? AND `state`!=?'
 }}}

 (found by instrumenting leasedb.py and piping the output through {{{|sort
 |uniq}}}).

 These are not queries that I would expect to use temporary tables, given
 that (`storage_index`, `shnum`) is the primary key on `shares`.

-- 
Ticket URL: <https://tahoe-lafs.org/trac/tahoe-lafs/ticket/1870#comment:27>
tahoe-lafs <https://tahoe-lafs.org>
secure decentralized storage