RevK :verified_r: on Nostr: Chasing SQL performance. And chasing. And chasing and finding the slow queries. But ...
Chasing SQL performance.
And chasing.
And chasing and finding the slow queries.
But no, forget them...
And down to "that is 0.175s" and well is that a problem"?
And Oh, fuck, that is done 27000 times each run?
Let's make that actually two separate queries, each 0.000s or 0.001s
Fuck that changes things
SQL is fun.
Published at
2024-08-01 13:54:54Event JSON
{
"id": "26fe7962321aa55257da05d73cf6022c77b259a67f318ef6b185837e8bdbb073",
"pubkey": "55c518ad55d4748c443e08724862133f0b42a32fcad2eac9a6edfbb71ca44e98",
"created_at": 1722520494,
"kind": 1,
"tags": [
[
"proxy",
"https://toot.me.uk/@revk/112887103146677582",
"web"
],
[
"proxy",
"https://toot.me.uk/users/revk/statuses/112887103146677582",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://toot.me.uk/users/revk/statuses/112887103146677582",
"pink.momostr"
],
[
"-"
]
],
"content": "Chasing SQL performance.\nAnd chasing.\nAnd chasing and finding the slow queries.\nBut no, forget them...\nAnd down to \"that is 0.175s\" and well is that a problem\"?\nAnd Oh, fuck, that is done 27000 times each run?\nLet's make that actually two separate queries, each 0.000s or 0.001s\nFuck that changes things\nSQL is fun.",
"sig": "6396bdb2abe5b370c74166341dbf8e213c76b1c6099114245d950d94da1070e4e5eccb1fd0066f581de642ec8023794dbcc9c8e918212009f553aa87bbaeb900"
}
