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!
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
0
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
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
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!
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
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
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.