Matt BaerAug 11, 2023

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!

Show threadBen Zanin
@matt hmm, it might be easier to have a structured conversation investigation perf issues in a forum where it's easier to share log files and the like. Is there a github issue tracking this already?
Aug 11, 2023 at 2:49pmTusky
Show threadMatt BaerAug 11, 2023
@gnomon Great point -- I've just opened an issue here with some things I've tried: https://github.com/writefreely/writefreely/issues/741
Rendering a blog is slow for giant databases · Issue #741 · writefreely/writefreely

Describe the bug On our Write.as instance, our posts table has over 4.25 million rows. For an individual blog with 9,000+ posts, rendering the blog index page is taking a long time (4 seconds or mo...

GitHub