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: /
npub1gz…cjdp9
2024-08-01 13:54:54
Author Public Key
npub1gzmg2lwnlvej57la2np3dkgzvt530jj0n2xhhp4evepvc9rdx03qtcjdp9Published at
2024-08-01 13:54:54Event JSON
{
"id": "d118df936aadb96cca3cbac489855ba6bf1330879e7fb38e70cdb9fb5dc4477a",
"pubkey": "40b6857dd3fb332a7bfd54c316d90262e917ca4f9a8d7b86b96642cc146d33e2",
"created_at": 1722520494,
"kind": 1,
"tags": [
[
"proxy",
"https://toot.me.uk/users/revk/statuses/112887103146677582",
"activitypub"
]
],
"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": "1b0495a07842fce8116652b18091079f7aa9fd5d0d93909a9f31076135d7194ca24225109d100c9233cfcb2c434a248b96ff18cdb560b2f9cf15894550e01826"
}