matrix07012 :thotpatrol: :cunnyEmpire: on Nostr: Sun What seems to be the bottleneck? My uneducated guess is that it's just bad DB ...
Sun (nprofile…h6f2) What seems to be the bottleneck?
My uneducated guess is that it's just bad DB design because I never saw a DB bottleneck with Mastodon.
What I usually saw was just requests not getting fulfilled fast enough because Ruby is slow and that was always solved by more processes and more CPU and RAM. SPW is on a dedi right?
Published at
2025-03-14 14:50:08Event JSON
{
"id": "8706eaed838b5c268418bef657bb3f0a6263e29962c3ac5a3efc6a7b658a5548",
"pubkey": "396a26bb2a6c4942c93938a96b14bf5cf947cfd06291e446b5182990baefffd7",
"created_at": 1741963808,
"kind": 1,
"tags": [
[
"p",
"05de5f2d3b8d98f9b929695080ae6aa51b14f00dc122eef1d40d502a0ab48154",
"wss://relay.mostr.pub"
],
[
"e",
"d034a3d6629a6d6e83a8f53688d4045732968e304dcf0d581c290ae652fb1915",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://gameliberty.club/users/matrix/statuses/114161340160220465",
"activitypub"
]
],
"content": "nostr:nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqqh097tfm3kv0nwffd9ggptn255d3fuqdcy3wauw5p4gz5z45s92qysh6f2 What seems to be the bottleneck? \nMy uneducated guess is that it's just bad DB design because I never saw a DB bottleneck with Mastodon. \nWhat I usually saw was just requests not getting fulfilled fast enough because Ruby is slow and that was always solved by more processes and more CPU and RAM. SPW is on a dedi right?",
"sig": "f288c0f9ba885ecc8744589d929548ed2be7c0e5204ba00c0f6c89727aa75a36de6a2b0b8f524cbda7abed3b1f5d83b32902cf8a652a912f24a32bc5a449f9aa"
}
