[tahoe-lafs-trac-stream] [tahoe-lafs] #1864: turn off the AUTOINCREMENT feature in our use of sqlite?

[tahoe-lafs]

#1864: turn off the AUTOINCREMENT feature in our use of sqlite?
-------------------------+-------------------------------------------------
     Reporter:  zooko    |      Owner:  warner
         Type:           |     Status:  new
  enhancement            |  Milestone:  1.11.0
     Priority:  normal   |    Version:  1.9.2
    Component:  code-    |   Keywords:  sqlite design-review-needed leasedb
  storage                |
   Resolution:           |
Launchpad Bug:           |
-------------------------+-------------------------------------------------

Comment (by davidsarah):

 Note that in [https://github.com/davidsarah/tahoe-
 lafs/commit/b7cea9a3f86c5cc4cfd3910d0300a1008b7b5a13], I got rid of the
 AUTOINCREMENT key on the `leases` table, replacing it with a semantic
 primary key. So there are no longer any AUTOINCREMENT keys on leasedb
 tables where records are created at all frequently. Therefore, I think
 there is no available performance improvement from this change, at least
 for leasedb.

 If you (zooko or warner) agree, I'll just close this ticket as invalid.

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