Semisol on Nostr: takes a few seconds to scan gigabytes of JSON in a table with 800k or so records so ...
takes a few seconds to scan gigabytes of JSON in a table with 800k or so records so why should I not?
Published at
2023-07-05 10:58:29Event JSON
{
"id": "1ab71a57942576134d00dba1219a99127c63fa6b09c17302e045f23922dbb67d",
"pubkey": "52b4a076bcbbbdc3a1aefa3735816cf74993b1b8db202b01c883c58be7fad8bd",
"created_at": 1688554709,
"kind": 1,
"tags": [
[
"e",
"5a9df4ccfddcfee95d0f6ce2361aa55eb06679c0e56eed397a9a30781ef61d6f",
"",
"root"
],
[
"e",
"9682d5f39f0419d13b3cdfb2ad9bbb6750adf192a87edb54b328ac006e0ce287",
"",
"reply"
],
[
"p",
"8fb140b4e8ddef97ce4b821d247278a1a4353362623f64021484b372f948000c"
]
],
"content": "takes a few seconds to scan gigabytes of JSON in a table with 800k or so records so why should I not?",
"sig": "9c6fa13eae81de0262103a8b36ce9760685a6c055d526ccdb790b1d8595f9ae4c8dd42c87259a6763cb14906ea9c586e81b7ec2597ea1171e6eddb2ab07513ba"
}
