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.
Unfortunately, activation email could not send to your email. Please try again.

Datatable

Thread ID:

Created:

Updated:

Platform:

Replies:

24562 Feb 7,2005 10:27 AM Feb 7,2005 08:05 PM Windows Forms 3
loading
Tags: GridControl
Administrator [Syncfusion]
Asked On February 7, 2005 10:27 AM

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 01:11 PM

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 05:29 PM

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 7, 2005 08:05 PM

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.

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.

;