scsibug on Nostr: SQLite can use many cores, and even multiple processes. There are some gotchas, but ...
SQLite can use many cores, and even multiple processes. There are some gotchas, but generally speaking it can use every core available for queries (especially reads).
Published at
2023-02-15 19:04:49Event JSON
{
"id": "73ee1e30807528a7f44d4b8687692a346228a78130740c82b4e955dbf5b8378a",
"pubkey": "35d26e4690cbe1a898af61cc3515661eb5fa763b57bd0b42e45099c8b32fd50f",
"created_at": 1676487889,
"kind": 1,
"tags": [
[
"e",
"f48a353ede8f0b69cf04b15c53fd7dc21a5c5ec451c4c35e32bd5b269115b6cc"
],
[
"e",
"1c7df0aa2c1612afba9949edcd9da972706b3e1ecd2da06bb88ca05822f1f780"
],
[
"e",
"cbb6bc28d6623e9311deadbcb54f9c6980fa2b71a2660ad4d31529f1d728d85e"
],
[
"p",
"2895c330c23f383196c0ef988de6da83b83b4583ed5f9c1edb0a559cecd1f900"
],
[
"p",
"35d26e4690cbe1a898af61cc3515661eb5fa763b57bd0b42e45099c8b32fd50f"
],
[
"p",
"e1ff3bfdd4e40315959b08b4fcc8245eaa514637e1d4ec2ae166b743341be1af"
]
],
"content": "SQLite can use many cores, and even multiple processes. There are some gotchas, but generally speaking it can use every core available for queries (especially reads).",
"sig": "e25cfdfe926797780bd3d4a3ff4ec4a6d08c4600624858d9521246d6325a5c3eb223bd61e9e3d8688cebc89147b91b7052e528c0b532465824b1422fe6af495e"
}
