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.
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
answered on 28 Feb 2011, 04:43 PM
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,
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!