Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Jarid Griesel
610
UltraWinGrid with BigData - DataTables or WinDataSource
posted

We are developing a WinForms application using UltraWinGrid. that will display very large datasets.

The application will receive it's data in the form of flat ADODB recordsets, some of which may approach 2GB in size.

The user may wish to drill through from any UltraWinGrid row into another tables data which would invloves adding child bands to WinGrid on the fly, later removing them and replacing them with other child bands on the fly.

Question

Given the above application scenario, what would be the best datasource for UltraWinGrid:

1) Infragistics WinDataSource, or

2) ADO.Net DataSets with data tables and relations.

The ability to handle very large datasets and performance are top priority.

Thanks in advance

 

 

 

Parents
No Data
Reply
  • 610
    Verified Answer
    Offline posted

    Hi There

    I have been involved in other projects and have only just gotten back to this.

    We downloaded the same chunk of SQL Server data into 3 different datasources and then bound those data sources to ultraWinGrid and then measured the memory consumed.
    The results were as follows:

    Data Source                      Memory Consumed
                                 
    Untyped dataset                          112 MB
    Strongly typed dataset                305 MB
    UltraWinDataSource                   713 MB

    So it would appear that untyped datasets are the best peformers from a memory usage point

Children
No Data