This is a migrated thread and some comments may be shown as answers.

Populate PivotGrid with over 5 million of registers from Oracle

3 Answers 6 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Sigsa
Top achievements
Rank 1
Sigsa asked on 24 Jul 2014, 06:49 PM
Hello Everyone,

I have a problem when I try to populate PivotGrid with over 5 million of registers from Oracle. For this I use Silverlight + RIA Services, but I don't know if this is the best way to do that.

The Oracle view has 28 colums with over 5 million of registers.

I would love to know if this is possible from this way, or maybe there are other way to do it best and faster by the performance.

I will appreciate any sort of help greatly! 

3 Answers, 1 is accepted

Sort by
0
Rosen Vladimirov
Telerik team
answered on 28 Jul 2014, 06:36 AM
Hi Sigsa,

When using data from Database, the only way to get correct results in RadPivotGrid is to get all items from the table and set them as ItemsSource of LocalDataSourceProvider. The amount of items that you can use as ItemsSource depends on the machine that is used and its hardware specification. This is because the items from the Database will be saved in the memory of the PC. Unfortunately there's no better way to achieve this. You can take a look at our XmlaDataProvider here, but you'll have to setup a cube from your database. This will boost the performance as the data will be aggregated in the cube itself and access to it will be much faster.

Hope this helps.

Regards,
Rosen Vladimirov
Telerik
 
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
 
0
Sigsa
Top achievements
Rank 1
answered on 31 Jul 2014, 10:06 PM
Hi Rosen

Thank you so much for your advices, I will check XmlaDataProvider. I hope this help us to resolve our issue. 
By the way, now we are working with telerik + WPF as an alternative for PC.

Regards!
0
Accepted
Rosen Vladimirov
Telerik team
answered on 01 Aug 2014, 05:13 AM
Hello Sigsa,

There are various resources over the net, which could help you to setup OLAP Cube and access to it. RadPivotGrid's XmlaDataProvider is designed to work with any Cube that supports Xmla protocol (by definition any cube should support this protocol to access its data). Oracle's Cubes support Xmla, so once you configure it, you should be able to show the data in RadPivotGrid. Here are some links that you may find useful:
 - Getting Started with Oracle Cubes
 - Debugging Xmla Problems

Hope this helps.

Regards,
Rosen Vladimirov
Telerik
 
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
 
Tags
PivotGrid
Asked by
Sigsa
Top achievements
Rank 1
Answers by
Rosen Vladimirov
Telerik team
Sigsa
Top achievements
Rank 1
Share this question
or