1 Reply Latest reply on Oct 17, 2018 8:31 AM by arvin.ramchurn

    Performace problem under 100 meg hyper extract

    arvin.ramchurn

      This is taking over 2 seconds to return,

      attached perf file

       

      <?xml version='1.0' encoding='utf-8' ?>

       

      <sqlproxy>

        <logical-query version='1.1.0'>

          <selects>

            <field>[none:Technology:nk]</field>

          </selects>

          <domainOp class='logical-operator' type='snowflake'>

            <aggregateOp class='logical-operator'>

              <measures />

              <groupbys>

                <binding name='[none:Technology:nk]'>

                  <identifierExp class='logical-expression' identifier='[none:Technology:nk]' />

                </binding>

              </groupbys>

              <joinOp class='logical-operator' join='inner' join-constraints='none'>

                <selectOp class='logical-operator'>

                  <predicate>

                    <funcallExp class='logical-expression' function='$SYS_NARY_AND$' shape='scalar'>

                      <funcallExp class='logical-expression' function='==' shape='scalar'>

                        <identifierExp class='logical-expression' identifier='[Indication Level 1]' />

                        <literalExp charset='0' class='logical-expression' collation='LEN_RUS' datatype='string' value='&quot;Cancer&quot;' />

                      </funcallExp>

                      <funcallExp class='logical-expression' function='&gt;=' shape='scalar'>

                        <identifierExp class='logical-expression' identifier='[Date (Indication)]' />

                        <literalExp class='logical-expression' datatype='date' value='#2014-01-01#' />

                      </funcallExp>

                      <funcallExp class='logical-expression' function='&lt;=' shape='scalar'>

                        <identifierExp class='logical-expression' identifier='[Date (Indication)]' />

                        <literalExp class='logical-expression' datatype='date' value='#2024-01-01#' />

                      </funcallExp>

                    </funcallExp>

                  </predicate>

                  <projectOp class='logical-operator'>

                    <expressions>

                      <binding name='[none:Technology:nk]'>

                        <identifierExp class='logical-expression' identifier='[Technology]' />

                      </binding>

                    </expressions>

                    <relationOp class='logical-operator' connection='' name='[sqlproxy]'>

                      <relation name='sqlproxy' type='table' />

                      <cols />

                    </relationOp>

                  </projectOp>

                </selectOp>

                <relationOp class='logical-operator' connection='' name='[#Tableau_17_01A4D05B-5FA3-465E-8B7F-C827B97B1C65_1_Filter]'>

                  <relation name='Filter_1' type='table' />

                  <cols>

                    <map key='[X_MoA (Full Description)]' value='[X_MoA (Full Description)]' />

                  </cols>

                </relationOp>

                <conditions>

                  <condition op='=='>

                    <identifierExp class='logical-expression' identifier='[MoA (Full Description)]' />

                    <identifierExp class='logical-expression' identifier='[X_MoA (Full Description)]' />

                  </condition>

                </conditions>

                <imports />

              </joinOp>

            </aggregateOp>

          </domainOp>

        </logical-query>

        <datasource hasconnection='false' inline='true' name='Parameters' version='18.1'>

          <aliases enabled='yes' />

          <column caption='Start Date' datatype='date' default-format='*YYYY' name='[Parameter 1]' param-domain-type='range' role='measure' type='quantitative' value='#2014-01-01#'>

            <calculation class='tableau' formula='#2014-01-01#' />

            <range granularity='1' max='#2024-01-01#' min='#2014-01-01#' period-type='year' />

          </column>

          <column caption='End Date' datatype='date' default-format='*YYYY' name='[Parameter 2]' param-domain-type='range' role='measure' type='quantitative' value='#2024-01-01#'>

            <calculation class='tableau' formula='#2024-01-01#' />

            <range granularity='1' max='#2024-01-01#' min='#2014-01-01#' period-type='year' />

          </column>

          <column caption='Number of products' datatype='integer' name='[Parameter 3]' param-domain-type='range' role='measure' type='quantitative' value='5'>

            <calculation class='tableau' formula='5' />

            <range max='10' min='1' />

          </column>

          <column caption='Number of Companies' datatype='integer' name='[Parameter 4]' param-domain-type='range' role='measure' type='quantitative' value='10'>

            <calculation class='tableau' formula='10' />

            <range max='10' min='1' />

          </column>

          <column caption='Number of Indications' datatype='integer' name='[Parameter 5]' param-domain-type='range' role='measure' type='quantitative' value='5'>

            <calculation class='tableau' formula='5' />

            <range max='10' min='1' />

          </column>

        </datasource>

      </sqlproxy>