We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Datatable

Thread ID:

Created:

Updated:

Platform:

Replies:

24562 Feb 7,2005 03:27 PM UTC Feb 8,2005 01:05 AM UTC WinForms 3
loading
Tags: GridControl
Administrator [Syncfusion]
Asked On February 7, 2005 03:27 PM UTC

Hello I''m using a Datatable as datasouce for a DataboundGrid. As performance is very important to us, did you have any experience for this ? It look likes the DataTable is a heavy in memory and CPU. Do you think we should implement our own "Table" ? Then i understant we have no sorting and no filtering Jane B.

Administrator [Syncfusion]
Replied On February 7, 2005 06:11 PM UTC

You might take a look at Syncfusion\Essential Suite\3.0.1.0\Windows\Grid.Windows\Samples\DataBound\GridPerf. It shows how to get optimal performance using a DataTable. Have not really tried this, but you could probably set up some simple load tests using an ArrayList of objects vs a DataTable as the datasource. This would allow you to judge whether gains in memory saving/performance would justify the additional work of trying to manage a custom collection class.

Administrator [Syncfusion]
Replied On February 7, 2005 10:29 PM UTC

Actually i did try both but i can''t see clearly the difference. The datatable take 40% more memory and both the datatable and the custom collection seem to consume the same processor %

Administrator [Syncfusion]
Replied On February 8, 2005 01:05 AM UTC

I think performance of datatables start to worsen when you start trying to add/remove records (particularly in a sorted DataTable). The way to get the fastest update performance is to use a virtual GridControl. This is more work on your part than using a GridDataBoundGrid as you would have to handle standard GridDataBoundGrid functionality like sorting or filtering in addition to the virtual events like QueryCellInfo and SaveCellInfo.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;