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

Too many SQL statements in Mondrian versions after 3.3.0 4703

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Not a Bug
    • Affects Version/s: 3.5.x (4.8.1 GA Suite Release), 3.6.x (5.0.0 GA Backlog)
    • 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.
    • Browser:
      Mozilla Firefox 15.x
    • Operating System/s:
      Windows 7 (64-bit)

      Description

      Switching Mondrian from 3.3.0.14703 to 3.5.0, or 3.6.1 make the MDX queries very slow.
      The difference is in the number of SQL queries generated (one per member in the level).

      The behavior is well explained by chcor42, with examples, in the following thread :
      http://forums.pentaho.com/showthread.php?130133-too-many-sql-queries-with-mondrian-3-4-1

      According to this thread, everyone having this issue downgrades to 3.3.0.
      Shall we wait for Mondrian 4 ? or is there something to fix in the cube or mondrian.properties ?

      I read several bugs about the number of sql queries, but they were related to hasAll=false, which is not the case here.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              kanai Anaik Trihoreau
            • Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: