Make KPI calculation and advanced filtering as fast as possible

XMLWordPrintable

    • High
    • Hide
      - Reduced task view refresh delay on certain filters change (match rate range, language resource type, language resource)
      - Increased KPI window load timeout to 60s
      - Optimized MariaDb/SQLite bulk write queries
      - Added optional usage of DuckDb CLI to directly query KPI-related data from a SQLite database file
      Show
      - Reduced task view refresh delay on certain filters change (match rate range, language resource type, language resource) - Increased KPI window load timeout to 60s - Optimized MariaDb/SQLite bulk write queries - Added optional usage of DuckDb CLI to directly query KPI-related data from a SQLite database file

      Make advanced filtering and kpi calculation as fast as possible without switching KPI data to ClickHouse Db.
       
      Research perfomance tuning of DB queries and related PHP code.

            Assignee:
            Volodymyr Kyianenko (Inactive)
            Reporter:
            Volodymyr Kyianenko (Inactive)
            Thomas Lauria
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: