I wrote a little python “bank” as a shitpost because of some stupid shit the BSV crowd were crowing about. Used SQLite and was actually really disappointed to see I maxed out at 93 transactions per second (on 5 year old consumer desktop hardware…)
Simply enabling WAL mode brought me up to 435 transactions per second. ~4.7x for free (for a write-heavy totally bogus/fake workload)
Ademan /
npub16sz…378f
2024-02-15 05:46:06
Author Public Key
npub16sz45sngz7k7ha48c9gekuaxc6gntujtynsfukdx6807m6lv7z5sgw378fPublished at
2024-02-15 05:46:06Event JSON
{
"id": "b22a87106a1d0e241a2dd59bb9429dce8a80aecf273549cd4cb756fc86a737f2",
"pubkey": "d4055a426817adebf6a7c1519b73a6c69135f24b24e09e59a6d1dfedebecf0a9",
"created_at": 1707972366,
"kind": 1,
"tags": [
[
"proxy",
"https://thebag.social/objects/ecea2bac-04e6-4817-8c34-38ca3ca9d0ca",
"activitypub"
]
],
"content": "I wrote a little python “bank” as a shitpost because of some stupid shit the BSV crowd were crowing about. Used SQLite and was actually really disappointed to see I maxed out at 93 transactions per second (on 5 year old consumer desktop hardware…)\n\nSimply enabling WAL mode brought me up to 435 transactions per second. ~4.7x for free (for a write-heavy totally bogus/fake workload)",
"sig": "5d9aada3190120bdc1eaa9bb24bd066e8ca467c7e22d51efe8e841472bd0d0c56c2d2da6b0c1466f3f20aea814bfd727e1053e601b476395c8ca5eb6b2ca13d3"
}