relayscan
relayscan copied to clipboard
Website: updating 7d stats data is super slow
Seems updating the 7d stats in the webserver can take up to 8 minutes. This is also blocking the webserver from starting at program startup.
Todo:
- Look at why it's so slow. Probably the Postgres database, either queries or the amount of data.
- Consider doing the aggregations in database query instead of loading all data and aggregating in the application