Performance issue: Update a particular column in large DataTable

  • Thread starter Thread starter Ajit Kumar Goel
  • Start date Start date
A

Ajit Kumar Goel

Hi;

I have a huge datatable consisting of approximately 1500 rows. Each
Row has approximately 30 columns. At the end of a operation, I update
a particular column for all the rows in the datatable. However this
takes a lot of time. (Approximately 40 seconds).

How do I go about reducing this time??.Any suggestions are welcome.

Kind Regards;

Ajit Goel
 
Try wrapping your update into BeginLoadData/EndLoadData. Keep in mind that
this can have side-effects
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging two DataTables in same data row 1
DataTable performance 1
Defining a block of consecutive rows in a datatable 8
how do I improve performance when updating external links? 2
Incrementally saving a DataTable 5
Discrepancy in DataGridView column order & databound DataTable 3
DataTable update cells slow 2
Slow Charts 2

Back
Top