Uploaded image for project: 'Magnolia DAM Module'
  1. Magnolia DAM Module
  2. MGNLDAM-1016

JcrAssetProvider querybuilder performance issues.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 3.0.16
    • 3.0.14
    • None
    • AuthX 8, AuthX 9, AuthX 10
    • 3

      After some more testing of our Magnolia 6 instance it was discovered that the asset chooser search options use a querybuilder built into JcrAssetProvider that suffers from similar performance issues as the JcrQueryBuilder (MAGNOLIA-8347).

      It also uses non-index queries with a like with wildcards on both ends. Which results in very slow queries.

      Also why does this not use the JcrQueryBuilder ?, there is a large overlap in the code with that.

        Acceptance criteria

          1. image-2022-04-06-16-42-18-558.png
            142 kB
            Lam Nguyen Bao
          2. image-2022-05-09-15-22-40-964.png
            30 kB
            Lam Nguyen Bao
          3. image-2022-05-09-15-23-21-588.png
            30 kB
            Lam Nguyen Bao

              lam.nguyen Lam Nguyen Bao
              rico.jansen Rico Jansen
              Mathijn Elhorst, Michiel Meeuwissen, Tim Molenaar
              AuthorX
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Bug DoR
                  Task DoD

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0d
                    0d
                    Logged:
                    Time Spent - 7d 1.75h
                    7d 1.75h