Make KPI calculation and advanced filtering as fast as possible

XMLWordPrintable

    • High
    • None
    • 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
    • None

      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)
            None
            None
            Thomas Lauria
            None
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:
              None
              None