By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,203 Members | 1,546 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,203 IT Pros & Developers. It's quick & easy.

Slow Performance on myTable.Rows.Add(newRow)

P: n/a
I am using a strongly typed dataset with a design time schema. I load
data into the dataset tables from xml. The problem I am having is
after the XML load. The first time I Add a row to a table I get very
slow performance (20-30 second delay). The add to table works but I
get slow performance. Any record adds or deletes after this first add
are fast. It does not seem to matter which table the record add
occurs. I get slow performance on the first add. I have no idea what
is causing this slow performance. In debugging, the time is spent on
the myTable.Rows.Add(newRow) line but I cannot figure out what is
delaying the add. Any thoughts on where I might be going wrong?
Any guidance would be welcomed!

Nov 17 '05 #1
Share this Question
Share on Google+
3 Replies

P: n/a
How much data is in the dataset ?

Nov 17 '05 #2

P: n/a
Very small....from 0 to about 5 records.

Nov 17 '05 #3

P: n/a
I did some more playing around and noticed that in my code I accidently
switched from strong typed dataset references to untyped references.
When I changed the code to use only strongly typed references the
performance is no longer slow. Any thoughts on why this might be the

Nov 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.