Why Nostr? What is Njump?
2023-08-11 14:28:06

Matt Baer on Nostr: I'm looking for a little help working through some database scaling issues with ...

I'm looking for a little help working through some database scaling issues with #WriteFreely.

On our Write.as instance, we're up to 4.25 million rows in our `posts` table, and it's causing problems for some individual blogs with 9,000+ posts.

I have an idea of what some bottleneck queries are. But wondering if there are easy db optimizations we might make (indexes, etc.), and if anyone can help identify what they might be.

Boosts appreciated!
Author Public Key
npub1eh33dlkkp8kgj6w8jffsn5wqpte8wwfavxl90xq0huu8h7qvdh5sk6ysfx