Daniel Supernault on Nostr: Just shipped another major performance improvement, a compound index for a frequently ...
Just shipped another major performance improvement, a compound index for a frequently run scheduled task.
From 877 seconds to 0.06 ms 🚀
#pixelfed
Published at
2026-09-07 08:38:28 UTCEvent JSON
{
"id": "e8e905ebd9fec41c220b7270d771836d8228220568598e49c9ee556937cbfa9f",
"pubkey": "fce95231cd584e791f1f5d977ceac1ef6edb3d3a7a29ada5a657979836cbcb1f",
"created_at": 1788770308,
"kind": 1,
"tags": [
[
"t",
"pixelfed"
],
[
"proxy",
"https://mastodon.social/users/dansup/statuses/117228850935461329",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content": "Just shipped another major performance improvement, a compound index for a frequently run scheduled task.\n\nFrom 877 seconds to 0.06 ms 🚀\n\n#pixelfed",
"sig": "4c27d72fa811b1e2d733fb30a77d50eee9652a67558fa817bf1d8d01ec91c63a98df04828aed4e132f62ccd2d2edffda25c9ff9a647577d33acd6352f4c840b4"
}
