Opened at 2017-02-23T19:34:36Z
Last modified at 2020-01-17T16:57:12Z
#2869 new defect
accounting: use twisted.enterprise.adbapi instead of blocking sqlite
| Reported by: | dawuud | Owned by: | |
|---|---|---|---|
| Priority: | normal | Milestone: | undecided |
| Component: | unknown | Version: | 1.12.1 |
| Keywords: | Cc: | ||
| Launchpad Bug: |
Description
The storage server cannot afford to block it's reactor with sqlite database queries for accounting... we need to switch to using an async io database access. Surely there's a driver for sqlite for the adbapi.
Change History (2)
comment:1 Changed at 2017-03-03T19:07:05Z by dawuud
comment:2 Changed at 2020-01-17T16:57:12Z by exarkun
Oh boy. Far from clear to me that adbapi is a step up from synchronous local sqlite3. Consider this carefully before spending any more work on it.
Note: See
TracTickets for help on using
tickets.
latest accounting dev branch now has the leasedb using twisted's async db api and passing it's unit tests but failing lots of other tests https://github.com/david415/tahoe-lafs/tree/accounting-3