sdgathman on Nostr: Just changed a variable to a constant (already known by the app) in an bunch of sql ...
Just changed a variable to a constant (already known by the app) in an bunch of sql queries to speed up by 10000. This reduces the runtime from 4.5 yrs to 3 hrs - much more reasonable.
Published at
2023-08-24 03:19:21Event JSON
{
"id": "584ed50723a6c3947c450e5f1f416054b4c49309b70471f3c0d2b0a87cf44a23",
"pubkey": "300ec228d0823779c529dc87278dea4b804cb258ef0f4ae6542125ee0222829e",
"created_at": 1692847161,
"kind": 1,
"tags": [
[
"p",
"12da98a3a66fb47b43526b1b241e91df632bfd4058dc5364938dc932fe931118",
"wss://relay.mostr.pub"
],
[
"p",
"49f3a746c8d602bb57f2fbcbcec59910fc8742b2c71c4609b3091709fc2a2375",
"wss://relay.mostr.pub"
],
[
"p",
"14fac33f299949ee9572e1b41c5e4de0f6e564f5499c64ff7de703213e94399f",
"wss://relay.mostr.pub"
],
[
"e",
"f1104da03ab08b4fc8aa9621a22de837c16318177a7605ff54a1873f093b6a0c",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://chatter.llamarific.social/objects/38972f16-0ce9-48db-a367-4d5029b0b9bf",
"activitypub"
]
],
"content": "Just changed a variable to a constant (already known by the app) in an bunch of sql queries to speed up by 10000. This reduces the runtime from 4.5 yrs to 3 hrs - much more reasonable.",
"sig": "4f726b48cb5d5db6fc24d998bf6e3a39538059de84207f7439d3449cac3c5dcbec881a8a5302f621b875f804b18dbed149fc5f570f80b57568d087c79ed108f6"
}