[JH] Performance Issue: Updating Single Column in 10000Records Vs Recreating New Data Table

Hi everyone I''m using v2.1.0.9 of GGC and am experiencing some major differences in performance. We using a DataTable as a DataSource for a grid with about 10,000 rows. Our application lets the user toggle the numeric value for a certain column - this is quite a complex calculation that needs to be done to update the column value for all records - so can''t use derived columns I''ve noticed that if I recreate the DataTable from scratch each time it takes about 5 seconds (includes creation, populating and binding to Grid)- which is fine I''ve just tried a different approach whereby I loop through all of the rows in DataTable and just update the column value that''s changed. I thought this would have been super efficient but it''s taking about 60 seconds rather than the 5 seconds to create from scratch. The only real difference is that I use Rows[index] enumerator to get the required row and update the column value - as oppose to cretaing a new row and adding to end of DataRowCollection I''ve used BeginUpdate, BeginLoadData and EndLoadData on both methods. I''m just wondering if there''s a bit more I need to do - could you suggest some events that I could hook into - I suspect things might be firing in the grid or Binder. Or perhaps IsDirty etc. There appears to be so many possible areas Thanks again for the great support Jason