| 6 Dec 2025 |
 aloisw | Key word is "can" here, it all depends on the actual use case. | 14:41:18 |
 Jassuko | Yes. So I guess we should figure out how to make it fast. :p | 14:41:51 |
 0x4fbb09 it/its ⛯✇ΘΔ | https://sqlite.org/fasterthanfs.html#write_performance_measurements goes into it | 14:43:27 |
| 0x4fbb09 it/its ⛯✇ΘΔ | write perf for sqlite writes in a single transaction vs the filesystem (with no fsync) is pretty much identical on linux | 14:43:59 |
| aloisw | Well yes, https://gerrit.lix.systems/c/lix/+/4711 and https://gerrit.lix.systems/c/lix/+/4712 are attempts to tweak SQLite settings to make it go a lot faster | 14:45:02 |
| Jassuko | 100s to 1000s of writes per second is where SQLite should start to get painful in general on many use cases. Anything below that, it should just work, or be easily fixable to perform. | 14:45:09 |
