Improve performance with materialized views

syxolk / euro2024

Euro 2024: Betting with your friends

https://www.wetten2024.de

51 stars 22 forks source link

Closed syxolk closed 4 weeks ago

syxolk commented 6 years ago

The app seems to perform quite good with 1000 users on a low-end server, however it could be easily optimized.

Make score_table a materialized view. It only needs to be updated whenever new match results are put in on the admin page and when a new user registers (also G+/FB)
Make past_matches_table a materialized view. Use the same update strategy.

syxolk commented 4 weeks ago

This is not really needed with the number of users I am expecting.