this post was submitted on 10 Jun 2023
683 points (99.3% liked)

Lemmy

12568 readers
1 users here now

Everything about Lemmy; bugs, gripes, praises, and advocacy.

For discussion about the lemmy.ml instance, go to [email protected].

founded 4 years ago
MODERATORS
 

How do you feel about the massive influx of users?

you are viewing a single comment's thread
view the rest of the comments
[โ€“] [email protected] 2 points 1 year ago (1 children)

Not necessarily a pain, you just have to model the data very differently in something like DynamoDB. Those views are secondary indexes.

Search, though, you're right. You'd be running ElasticSearch along side it and the cost and complexity starts to go up. Or just abandon having a functional search entirely, like Reddit did...

[โ€“] [email protected] 1 points 1 year ago

Ja, but you need an index for each thread, some kind of time partitioned thread index for each community, same for all.

Then you need to query all comments or posts by user, so that's another index, then you need some way of querying for hot, or controversial or what have you.

It's doable, but fiddly. Tempted to have a go though!