Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-641

Large NON EMPTY result performs poorly with ResultStyle.ITERABLE

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Not a Bug
    • Affects Version/s: 3.1.2 GA
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      The query below takes around 99 seconds on my laptop when executed with result style set to ResultStyle.ITERABLE. It runs in around 10 seconds with ResultStyle.LIST.

      RolapNativeSet choses whether to use a SqlTupleReader (which internally uses an ArrayList) or a HighCardSqlTupleReader (which uses a LinkedList) based on the ResultStyle--LIST -> SqlTupleReader, ITERABLE -> HighCardSqlTupleReader. Use of a linked list for many queries is inefficient.

      select non empty

      { crossjoin( customers.[city].members, crossjoin( [store type].[store type].members, product.[product name].members)) }

      on 0 from sales

        Activity

        Hide
        kcruzada Kurtis Cruzada added a comment -

        Can you comment on this... is it fixed?

        Show
        kcruzada Kurtis Cruzada added a comment - Can you comment on this... is it fixed?
        Hide
        jhyde Julian Hyde added a comment -

        It is not fixed. Bug.java still has "public static final boolean BugMondrian641Fixed = false;".

        Show
        jhyde Julian Hyde added a comment - It is not fixed. Bug.java still has "public static final boolean BugMondrian641Fixed = false;".

          People

          • Assignee:
            Unassigned
            Reporter:
            mkambol mkambol
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: