view client/public/index.html @ 4449:ce884af9f42f

Fix forecast accuracy values and improve performance Forecast accuracy should be based only on the most recent predictions. Generally consider measurements and predictions older than 14 days as outdated and irrelevant. This also implies a performance gain, since it saves a full scan of gauge_measurements and the extra index for this purpose. Adding an extra subquery level for calculation of the forecast accuracy per row instead of the function call as a FROM item saves a (nested loop) join, which is another performance gain.
author Tom Gottfried <tom@intevation.de>
date Fri, 20 Sep 2019 13:22:45 +0200
parents 4cebd0a1f41f
children 7a3ace19dc56
line wrap: on
line source

<!--
  This is Free Software under GNU Affero General Public License v >= 3.0
  without warranty, see README.md and license for details.

  SPDX-License-Identifier: AGPL-3.0-or-later
  License-Filename: LICENSES/AGPL-3.0.txt

  Copyright (C) 2018, 2019 by via donau
   – Österreichische Wasserstraßen-Gesellschaft mbH
  Software engineering by Intevation GmbH
-->
<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge" />
    <meta name="viewport" content="width=device-width,initial-scale=1.0" />
    <link rel="icon" href="<%= BASE_URL %>favicon.ico" />
    <title>gemmajs</title>
    <style>
      html {
        height: 100%;
        width: 100%;
        margin: 0 auto;
      }
      body {
        height: 100%;
        width: 100%;
        background-color: #efefef !important;
      }
    </style>
  </head>

  <body>
    <noscript>
      <strong
        >This webapplication needs Javascript enabled to run. Please enable it
        to continue.</strong
      >
    </noscript>
    <div id="app"></div>
    <!-- built files will be auto injected -->
  </body>
</html>