Comment by makapuf

3 months ago

SQLite is in process, but concurrent write / performance is a complex matter : https://sqlite.org/wal.html

3 comments

makapuf

Reply
kevinak  3 months ago

Yes, that's why I would expect it to smoke Postgres here, in process is orders of magnitude faster. Do you really need concurrency here when you can do 10-100k+ inserts per second?

  • ies7  3 months ago

    If 100k users each hit purchase button at the same time will sqlite write it in 1 second?

    This is different than 1 user doing the purchase for 100k fans

    • kevinak  3 months ago

      I mean it depends on the query and what you're doing of course, but it's not impossible to reach writes/s in the 80k range.