Cy on Nostr: Wow... I just created a query that I'm running on a 15 megabyte sized sqlite ...
Wow... I just created a query that I'm running on a 15 megabyte sized sqlite database. It's been going at 100% CPU for like 3 minutes. How do you even make a query that takes that long on that little data? It's not even an insert or update, just a select. #wtf
Published at
2024-12-15 19:50:17Event JSON
{
"id": "6a6e2bcd7cef22d3e9378295a38dac74eec6bacc36074ade073f745120bc22ef",
"pubkey": "bd9bf6b093eae31b2d42eeab8d71227ea77991ac6a1c8e6861d64e8ba508c327",
"created_at": 1734292217,
"kind": 1,
"tags": [
[
"t",
"wtf"
],
[
"proxy",
"https://fedicy.us.to/cy/p/1734292217.356128",
"activitypub"
]
],
"content": "Wow... I just created a query that I'm running on a 15 megabyte sized sqlite database. It's been going at 100% CPU for like 3 minutes. How do you even make a query that takes that long on that little data? It's not even an insert or update, just a select. #wtf\n",
"sig": "3d21023891fd8176b0fc7a1db56cbf0c2d785583fc92bcfcec278422e55b7a8d8199f586c40d140130827d62616909a94e1aa177f764b247791411ba796ea1df"
}
