andrew on Nostr: Bitcoin is relatively tiny thanks to small blocks. All reasonable queries should be ...
Bitcoin is relatively tiny thanks to small blocks. All reasonable queries should be O(1) and instant on a 10-year-old laptop with a decent schema. Unreasonable queries can be optimized for.
Will check the bigquery schema, thanks.
Published at
2023-01-14 07:21:08Event JSON
{
"id": "56d22f9f4f65785639b87f664ee40ec6a48fa1940515a28773759911a35b8343",
"pubkey": "b726de20b515705ffee951591e8f54f42f93bb8509df81a851cd5bc949ec1332",
"created_at": 1673680868,
"kind": 1,
"tags": [
[
"e",
"30870702661f4b8094d61d695dddfacd82cc3b9d9ff4d9a456ffb85e8898bbca",
"",
"root"
],
[
"e",
"56daad129c2870dc8c4d91ec7d5af9a1721f263cf34e94f3b0d9b03291ad0bef",
"",
"reply"
],
[
"p",
"2590201e2919a8aa6568c88900192aa54ef00e6c0974a5b0432f52614a841ec8"
]
],
"content": "Bitcoin is relatively tiny thanks to small blocks. All reasonable queries should be O(1) and instant on a 10-year-old laptop with a decent schema. Unreasonable queries can be optimized for. \n\nWill check the bigquery schema, thanks.",
"sig": "8bc2804ca9e4c0d9a1d4387b779af55c35d528b5c703dd57b1fd8efa80a7bfcbcbf21eb5a1b1c144dca1ad6b34f3d1c4dad2585e231c94d1849cc73c45f25500"
}
