Cy on Nostr: It's so cool to have a table of blurbs of text, with a language and a mimetype for ...
It's so cool to have a table of blurbs of text, with a language and a mimetype for each of them. And translations between blurbs, and blurb revisions. But it does noticeably slow things down to join with blurbs every time. Like, by milliseconds per row. Getting 32 people with 3 posts each takes like 60 seconds. I don't get it. It's just joining on the primary rowid of blurbs, and both posts.summary and posts.content are indexed.
Other stuff is also making getting that summary of people and posts incredibly slow. Just don't know enough about databases to do this. So fucking alone...
Published at
2024-11-30 07:17:38Event JSON
{
"id": "ed2cca26733ef3ef26bb56d8d16ae0bdbc24bd8adf9d090b74c4ff8c4472f3ca",
"pubkey": "bd9bf6b093eae31b2d42eeab8d71227ea77991ac6a1c8e6861d64e8ba508c327",
"created_at": 1732951058,
"kind": 1,
"tags": [
[
"proxy",
"https://fedicy.us.to/cy/p/1732951058.199775",
"activitypub"
]
],
"content": "It's so cool to have a table of blurbs of text, with a language and a mimetype for each of them. And translations between blurbs, and blurb revisions. But it does noticeably slow things down to join with blurbs every time. Like, by milliseconds per row. Getting 32 people with 3 posts each takes like 60 seconds. I don't get it. It's just joining on the primary rowid of blurbs, and both posts.summary and posts.content are indexed.\n\nOther stuff is also making getting that summary of people and posts incredibly slow. Just don't know enough about databases to do this. So fucking alone...\n",
"sig": "3340022ace6fa58cb8f1f0d2da36f2e77ba22999f389602de4cb7aebf426c05ed2793437a26e924591de7153fd45fc43828346594a870449a2305af28c6b7105"
}
