3 ms·
> Do you have a write-heavy workload? How do you handle contention? I'd also be interested in that. Last time I wanted to use Sqlite opening twice the same fil
by Boulth 8y ago
> Do you have a write-heavy workload? How do you handle contention?
I'd also be interested in that. Last time I wanted to use Sqlite opening twice the same file for writing either would not succeed or could time out.
- jacquesm 8y agoThat's because SQLite is meant for single user applications. If you try to open the file the second time it will wait to acquire the lock.
- WA 8y agoSingle process applications if I’m not mistaken. And somewhere in the docs it says: most writes take a few milliseconds at most, so even in a multi-process environment (say 5-10 PHP processes), it should be fine. Haven’t tried this though.
- deleted 8y ago[deleted]
- deleted 8y ago[deleted]