u/siliskleemoff

so I make a saas right? and its supposed to be a social media/content platform and I thought I handled everything...

the posts get pulled in paginated so users aren't querying all 2 million posts.

the issue is that the posts have millions of likes, comments, etc...

so when I'm joining tables and added up the counts with select count(*), that shit tanks performances and causes the worst load times of mankind!

how do I fix this bro? I asked AI and it sayed indexing won't work by itself.

Hey guys, I'm a full stack software developer building out my own "social media" or "content" platform right now and I'm trying to generate some revenue by placing ads on the site...

The content on the platform is pretty much entirely user generated. I get some traffic from Instagram and TikTok (mostly TikTok). Random anonymous ppl will drop in here and there to post something random.

It keeps getting rejected for low value content lol

Not sure what I'm doing wrong.

Here's the link if you guys could be as critical and helpful as possible so I can resolve this issue: https://saysomethingrandom.com