Uploaded image for project: 'translate5'
  1. translate5
  2. TRANSLATE-4692

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.

            volodymyr@mittagqi.com Volodymyr Kyianenko
            volodymyr@mittagqi.com Volodymyr Kyianenko
            Thomas Lauria
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: