Pentaho Analysis - Mondrian
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-641

Large NON EMPTY result performs poorly with ResultStyle.ITERABLE

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Critical Critical
    • Resolution: Unresolved
    • Affects Version/s: 3.1.2 GA
    • Fix Version/s: Mondrian Backlog
    • 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
        Kurtis Cruzada added a comment -
        Can you comment on this... is it fixed?
        Show
        Kurtis Cruzada added a comment - Can you comment on this... is it fixed?
        Hide
        Julian Hyde added a comment -
        It is not fixed. Bug.java still has "public static final boolean BugMondrian641Fixed = false;".
        Show
        Julian Hyde added a comment - It is not fixed. Bug.java still has "public static final boolean BugMondrian641Fixed = false;".

          People

          • Assignee:
            Julian Hyde
            Reporter:
            mkambol
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: