I've been running this for most of the day now, and it seems to be able to keep up. Although I see some lags where it lags a couple of minutes when it needs to process many feeds at once. The bottleneck is the database, which is clear to me. I'll let this run this weekend, so that Azure SQL Database can figure out which queries can benefit from which indexes, and see how the performance profile is after that.
Next is to figure out what the client (app) architecture is going to be.
Barry Luijbregts /
npub1fk…h84sp
2024-08-30 11:46:36
Author Public Key
npub1fkfpdaq0afafls4dpwznaqquuxxwm99qv579e8862sq3kzhsdzksgh84spPublished at
2024-08-30 11:46:36Event JSON
{
"id": "1e09ec98d10081c04ed4ad7fee6023d2b5b5dbd46bf6f5923bcf6ca9a1caa418",
"pubkey": "4d9216f40fea7a9fc2ad0b853e801ce18ced94a0653c5c9cfa54011b0af068ad",
"created_at": 1725018396,
"kind": 1,
"tags": [
[
"proxy",
"https://podcastindex.social/@podhome/113050805615261889",
"web"
],
[
"proxy",
"https://podcastindex.social/users/podhome/statuses/113050805615261889",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://podcastindex.social/users/podhome/statuses/113050805615261889",
"pink.momostr"
],
[
"-"
]
],
"content": "I've been running this for most of the day now, and it seems to be able to keep up. Although I see some lags where it lags a couple of minutes when it needs to process many feeds at once. The bottleneck is the database, which is clear to me. I'll let this run this weekend, so that Azure SQL Database can figure out which queries can benefit from which indexes, and see how the performance profile is after that.\n\nNext is to figure out what the client (app) architecture is going to be.",
"sig": "a00a36624685abba71aea26d3b04efa60f3e6edda5d6c310b64fe2ce3c49df16e865e5fd9ee42f90b9015cac5bdc1c2c038d21bb157d6c105197f5078883f635"
}