3 ms·
SQLIte mostly runs on slow CPU devices with relative fast SSDs. Reads are parallel, but writes are single threaded, so there is no advantage from multi core ARM
by qwerta 12y ago
SQLIte mostly runs on slow CPU devices with relative fast SSDs. Reads are parallel, but writes are single threaded, so there is no advantage from multi core ARM CPUs.
- bane 12y agoThe in-memory mode is also the default for many APIs. You can basically just use it like a collection for your language of choice but use SQL for putting and fetching things from the collection.
- onli 12y agoSqlite mostly runs everywhere, especially on normal desktop PCs, including all those old ones with slow HDDs and relatively powerful CPUs. But I don't get the ARM CPU remark, did parent change his comment?
- loudmax 12y agoNot for the same database obviously, but SQLite databases are cheap. If your data can be split into different databases, you can pull off parallel writes.