5 ms·
Well, let me throw out a crazy idea: Nobody said you have to use a single database/file. Obviously, you are going to want to spend a couple minutes thinking a
by OldHand2018 6y ago
Well, let me throw out a crazy idea:
Nobody said you have to use a single database/file. Obviously, you are going to want to spend a couple minutes thinking about referential integrity. But how often do you delete records in your web app?
- quesera 6y agoUPDATE is also a write, and references crossing files sounds like a nightmare. If your deployment environment has serious constraints, I'm sure you could make it work. The product you deliver would be SQLite + custom DBI layer to hide SQLite's limitations. It would be a lot more work, and not be as robust or scalable, compared to a more traditional selection. But I can imagine cases where it would be appropriate.
- HelloNurse 6y agoA big database id not an issue. Contention requires a large number of writers, not a large amount of cold data.
- kuschku 6y agoAs an IRC client with an SQLite backend: several hundred times per second. Per user. While reads are more like once every day per user.