TableAdaper Fill spikes processor

[gmccallum]

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
gm*******@honovi.com

[Nicholas Paldino [.NET/C# MVP]]

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.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"gmccallum" <gm*******@discussions.microsoft.comwrote in message
news:90**********************************@microsof t.com...

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
gm*******@honovi.com