Performance issue - realation source

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

  • Posted 3 August 2017, 3:55 pm EST

    Hi !<br><br>I connect Active Analysis <span class="translation">through </span>OLEDB to Oracle in my program:<br><br>Private Sub ConnectToSource()<br>    If Me.RdData_Source.IsConnected Then<br>      Me.RdData_Source.Disconnect()<br>    End If<br>    Me.RdData_Source.ConnectionString = "Provider=<b>msdaora</b>;Data Source=myDWH;User Id=test;Password=lala;"<br>    Me.RdData_Source.ConnectionType = ConnectionType.OleDb<br>    ' <b>myTable <span class="translation">contain</span> 170 000 records</b><br>    Me.RdData_Source.QueryString = "SELECT country, region, town, product, cost FROM myTable"<br>    Me.RdData_Source.CustomSchemaFile = Application.StartupPath & "\reqTest.schema" <br>    Me.RdData_Source.Connect()<br>    _pivotView.DataSource = Me.RdData_Source<br>End Sub<br><br>This code work <span class="translation">successfully<br>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><br>(workstation - Pentium IV 2</span><span class="translation">GHz 2 CPU, 2</span>Gb RAM, HDD 7200ppm)<br><b><span class="translation"><br></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)<br><br>Can You speed up RelationDataSource, unboundDataSource ???<br>
  • Replied 3 August 2017, 3:55 pm EST

    <font size="2"><font face="Verdana">Hello, </font><br><br></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"><br>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.<br><br>Also take a look at this KB article on optimizing ActiveAnalysis. <br><br>Regards,<br>Aashish<br></font><br><br>
Need extra support?

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

Learn More

Forum Channels