nuts_cash on Nostr: And deleting stuffs also keep the database busy, which in turn make it slower Things ...
And deleting stuffs also keep the database busy, which in turn make it slower
Things seems ok as long as I query from indexed fields and not more than 5 posts at the same time.
Have yet to find a good approach for deleting stuffs, if I delete the old stuffs my client will no longer query it because of the since field.
Published at
2024-09-28 05:31:41Event JSON
{
"id": "928a44dc3bb497757bb7a13ab209f3474d5df79d82169e2eb1125af1128528c8",
"pubkey": "7726c437ccf791f6ded97dbac1846e62019e5fbd24f42e9db2f640f231c3c09a",
"created_at": 1727501501,
"kind": 1,
"tags": [
[
"e",
"b1e46ba7f5034638bd80df904d62736ddc33f09a8d76ebd7bc9923b4ef89ec02",
"",
"root"
],
[
"e",
"ff4a15d1f913061ad44c066700c51c076fd96dedf967492e059bfbca59c23dab"
],
[
"p",
"460c25e682fda7832b52d1f22d3d22b3176d972f60dcdc3212ed8c92ef85065c"
]
],
"content": "And deleting stuffs also keep the database busy, which in turn make it slower\n\nThings seems ok as long as I query from indexed fields and not more than 5 posts at the same time.\n\nHave yet to find a good approach for deleting stuffs, if I delete the old stuffs my client will no longer query it because of the since field.",
"sig": "953ec2b9fdc51ff3638f78671495353093974212bc99def52c0699888da404e6d2bf5810462a21a003df6f07446015a8b2c024eb56b7b04e86abb547f314bea6"
}
