Populate PivotGrid with over 5 million of registers from Oracle

4 posts, 1 answers
  1. Sigsa
    Sigsa avatar
    4 posts
    Member since:
    Jun 2009

    Posted 24 Jul 2014 Link to this post

    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! 
  2. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 28 Jul 2014 Link to this post

    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.
     
  3. DevCraft banner
  4. Sigsa
    Sigsa avatar
    4 posts
    Member since:
    Jun 2009

    Posted 31 Jul 2014 Link to this post

    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!
  5. Answer
    Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 01 Aug 2014 Link to this post

    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.
     
Back to Top