rundfunk-mitbestimmen icon indicating copy to clipboard operation
rundfunk-mitbestimmen copied to clipboard

Landing page: Database view for summarized statistics

Open roschaefer opened this issue 7 years ago • 0 comments

  • I'm submitting a ...

    • user interface improvement
  • What is the current behavior? There are four different database requests in the backend on the landing page. This adds 50ms-1s to the initial load of the landing page.

  • What is the expected behavior? Just one database request on a dedicated database view.

  • What is the motivation / use case for changing the behavior? Reduce initial page load time. Especially the landing page should have the smallest possible page load time. We could also simplify other views using this view as a sub-query.

  • What could be a possible solution? (not obligatory) Create a database view e.g. Statistic::Summary in order to reduce the number of database requests.

roschaefer avatar Oct 16 '17 10:10 roschaefer