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

Fast and Responsive GridView for data acquisition

2 Answers 115 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Daniel
Top achievements
Rank 1
Daniel asked on 24 Feb 2011, 01:15 AM

I'm evaluating buying the RadControls WinForms for the following use case:

To log millions of messages into a customizable grid GUI (e.g. similar features of Telerik's Win Forms Datagrid).

Since this should be used for logs from specific hardware I'm forced to use as a storage a file or a flat database (I don't want to use SQL server or so).

The gridview shall be customizable and fast on inserting new rows and when grouping/filtering/formatting. All these operations need to be done while the grid collects data on a pace of ~1000 events/second.

Would you recommend your grid for this purpose?

2 Answers, 1 is accepted

Sort by
0
Richard Slade
Top achievements
Rank 2
answered on 24 Feb 2011, 12:45 PM
Hello Daniel,

Whilst I can't specifically say yes to all of your questions without fully testing the scenario, I can give you a recommendation from my own experience of using the RadGridView.

We use the RadGridView, and indeed all of the Telerik controls for WinForms in a variety of different types of forms, some of which collect data on a minute by minute basis. The feature set of the Telerik RadGridView is second to none and performance is generally excellent. (have a look at the demos on your PC under GridView >> Performance >> Load 50,000 rows and High Refresh.)

The Telerik controls generally follow the same implementations as the standard Microsoft grid, but with obvious feature enhancements. In honesty, any GridView component that implements this many features is never going to be quite as fast as the standard control, but for us at least, the additional benefits that come from the themes, and range of features far outweigh any disadvantage.

The RadGridView implements a neat UI Virtualization system that improves performance. This means that only the rows that are currently visible have a visual element. When the grid is scrolled up and down the visual elements are reused. This is obviously good for performance as the RadGridView does not create visual elements where it doesn't need to. You can read more about this structure in this documentation.

I hope this helps somewhat and that you choose to use Telerik's products. Personally, I firmly believe that they are the best on the market.
All the best
Richard
0
Stefan
Telerik team
answered on 28 Feb 2011, 04:43 PM
Hello Daniel,

Thank you for writing.

Our grid is mostly a UI control and it is not designed to handle millions of rows of data since for every row it will create a new object and this will consume a lot of memory. In fact such a large amount of data should be handled by servers (SQL, Oracle) and not by WinForms controls. RadGridView works with great performance for most business needs where just a few thousand rows are displayed. Additionally, operations such as filtering, grouping etc. may take some time if they are applied to a large amount of data.

Should you have any other questions, do not hesitate to contact us.
 
All the best,
Stefan
the Telerik team
Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
Tags
GridView
Asked by
Daniel
Top achievements
Rank 1
Answers by
Richard Slade
Top achievements
Rank 2
Stefan
Telerik team
Share this question
or