Uploaded image for project: 'Red Hat Advanced Cluster Security'
  1. Red Hat Advanced Cluster Security
  2. ROX-31466

Refactor the N+1 query for GetAllPolicies

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Unresolved
    • Icon: Normal Normal
    • None
    • None
    • Central
    • None
    • Quality / Stability / Reliability
    • False
    • Hide

      None

      Show
      None
    • False
    • Not Selected

      Overview

      Related to https://issues.redhat.com/browse/ROX-31365

      We're doing N+1 DB queries for each GetAllPolicies call, with N being the number of policies stored in the DB.

      We should investigate whether we can get that down to some fewer queries. Initial investigation with AI show 3 queries are possible when we do some in-memory matching in central, 1 query when we bypass the query framework of central and send a raw join/aggregate.

              rh-ee-jmalsam Johannes Malsam
              rh-ee-jmalsam Johannes Malsam
              ACS Cloud Service
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: