[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):

 I added this to `dbutil.py`, and the strace output no longer shows any
 files in `/var/tmp` being opened:
 {{{
     # Store temporary files not associated with transaction control in
 memory
     # where possible, provided that sqlite has been compiled to allow
 that. See
     # <http://www.sqlite.org/tempfiles.html> and
     # <http://www.sqlite.org/pragma.html#pragma_temp_store> for details.
     c.execute("PRAGMA temp_store = MEMORY;")
 }}}

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