Performance issue - realation source

Posted by: superbluesman on 3 August 2017, 3:55 pm EST

  • Posted 3 August 2017, 3:55 pm EST

    Hi !

    I connect Active Analysis <span class="translation">through </span>OLEDB to Oracle in my program:

    Private Sub ConnectToSource()
        If Me.RdData_Source.IsConnected Then
        End If
        Me.RdData_Source.ConnectionString = "Provider=<b>msdaora</b>;Data Source=myDWH;User Id=test;Password=lala;"
        Me.RdData_Source.ConnectionType = ConnectionType.OleDb
        ' <b>myTable <span class="translation">contain</span> 170 000 records</b>
        Me.RdData_Source.QueryString = "SELECT country, region, town, product, cost FROM myTable"
        Me.RdData_Source.CustomSchemaFile = Application.StartupPath & "\reqTest.schema"
        _pivotView.DataSource = Me.RdData_Source
    End Sub

    This code work <span class="translation">successfully
    but when I drag&drop </span>"town" (170 000 towns) to rows-area - <b>pivotView work very very </b><span class="translation"><b>slowly</b>
    (workstation - Pentium IV 2</span><span class="translation">GHz 2 CPU, 2</span>Gb RAM, HDD 7200ppm)
    <b><span class="translation">
    </span><span class="translation">Though </span><span class="translation">similar </span>query in Excel2007 work </b><span class="translation"><b>acceptably</b> (Sheet1: </span>query to Oracle -170 000 rows --> Sheet2: Pivot table based on data of Sheet1)

    Can You speed up RelationDataSource, unboundDataSource ???
  • Replied 3 August 2017, 3:55 pm EST

    <font size="2"><font face="Verdana">Hello, </font>

    </font><font face="Verdana" size="2">If you are using a relational database
    then performance is highly dependent on the number of rows in the query as well
    as the number of attributes/measures you define.</font><font face="Verdana" size="2">
    I would suggest you to try using Analysis Services as a data source. In this case since queries are passed to the server and only the needed data is returned, the processing can be much faster.

    Also take a look at this KB article on optimizing ActiveAnalysis.


Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels