relayscan icon indicating copy to clipboard operation
relayscan copied to clipboard

Website: updating 7d stats data is super slow

Open metachris opened this issue 1 year ago • 2 comments

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

metachris avatar Feb 23 '24 12:02 metachris