Datatable

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.

3 Replies

AD Administrator Syncfusion Team 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.


AD Administrator Syncfusion Team 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 %


AD Administrator Syncfusion Team 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.

Loader.
Up arrow icon