steven on Nostr: I asked ChatGPT to optimize this slow running SQL query. It sped it up by 43%. All ...
I asked ChatGPT to optimize this slow running SQL query.
It sped it up by 43%. All tests pass.
Wow.
Before:
After:
Published at
2022-12-24 09:44:30Event JSON
{
"id": "20084eed038e71f7f13dd1d3caacbe9f44a111af5e70284193c6895686fe5b93",
"pubkey": "3f2a859b68e9cf09c9c7a9d7173b8a66b14557261c7b8376df100af73eb12e3d",
"created_at": 1671875070,
"kind": 1,
"tags": [
[
"client",
"astral"
]
],
"content": "I asked ChatGPT to optimize this slow running SQL query.\nIt sped it up by 43%. All tests pass. \n\nhttps://i.imgur.com/PsJ3ItB.png\nhttps://i.imgur.com/8JlMclW.png\n\nWow.\n\nBefore: https://i.imgur.com/pssY9E7.png\nAfter: https://i.imgur.com/lLg79uN.png",
"sig": "a41ba073d319d881de99a2d5de2d57ecc5596cf3658203c15019e28007b2ee08dff360b4f2d049ef3ab0d939c6665cb7b6a62ec34ca08d5a9fa3184123490d2d"
}
