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
    • Component/s: None
    • Labels:
      None

      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: