search

kyle1373 / Archiverse

The biggest Miiverse archive on the internet
https://www.archiverse.app
MIT License
9 stars 0 forks source link

Fix 504 gateway timeouts for users with extremely large number of posts #32

Closed kyle1373 closed 2 weeks ago

kyle1373 commented 2 weeks ago

This user has over 200,000 posts. Current indexes on the PostgreSQL database only have the ability to filter out posts by nnid and then manually sort using RAM. Here, sorting 200,000 posts is...insane. Goal here is to create indexes which automatically sort by PostedDate and EmpathyCount respectively. As I am writing this, these indexes are currently being created, and they will be finished probably in 6 hours.

https://www.archiverse.app/users/09183DS

kyle1373 commented 2 weeks ago

Indexes have been finished creating, and this issue no longer occurs. Closing now