Page loads slow when too millions of posts exist

Littlegolden

I found the site loads slower if there are more than 2 millions of posts.

the site always shut down with 502 bad gateway, I think it's the PHP execuses too long, so I've adjusted php and nginx (max_execution_time , memory_limit, request_terminate_timeout etc. ), but these seems a bit useful.

Are there are any other optimizations?

katos

Littlegolden I think more stats are needed here.
Can you let us have the output of php flarum info please?

luceos

The question would be what is talking so long. 4 million shouldn't pose any issues in terms of rendering the index. Multi word search on the other hand 🙈

Do you see any processes that peak cpu/memory?