4 ms·

Where is write contention coming from if it's operated locally?

• Thaxll 4y ago
  SQLite is "single" threaded for writes.
• d3nj4l 4y ago
  ... you can get tons of requests on a server?
  • dinosaurdynasty 4y ago
    Redis has the same limitation (only one transaction at a time) and is used a lot for webapps. It solves this by requiring full transactions up front. The ideal case for sqlite for performance is to have only a single process/thread directly interacting with the database and having other process/threads send messages to and from the database process.
  • innocenat 4y ago
    But that isn't "locally"?