TableAdaper Fill spikes processor

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why when I try to fill a dataset with about 10,000 rows using the Fill method
does it spike to processor to over 95% for a duration of time.

Is there no way to have this action performed without using so much processor?

Gregory McCallum, MCSD
(e-mail address removed)
 
I don't see how.

Basically, when you fill a data set, you are getting a data reader and
cycling through the rows in a loop.

On top of that, for each iteration of that loop, you are iterating
through the columns in a tight loop to add the new row values. For 10000
rows, that's going to cause a spike.
 
Back
Top