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.
RevK :verified_r: /
npub12h…4ynw4
2024-08-01 13:54:54
Author Public Key
npub12hz33t24636gc3p7ppeyscsn8u959ge0etfw4jdxahamw89yf6vq84ynw4Published 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"
}