469,631 Members | 1,218 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,631 developers. It's quick & easy.

Slow Performance on myTable.Rows.Add(newRow)

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!
Jerry

Nov 17 '05 #1
3 4303
How much data is in the dataset ?

rawCoder
Nov 17 '05 #2
Very small....from 0 to about 5 records.

Nov 17 '05 #3
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
case?

Nov 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by shankar | last post: by
reply views Thread by jdipalmajr | last post: by
2 posts views Thread by Steve Amey | last post: by
1 post views Thread by Peter Newman | last post: by
2 posts views Thread by mrajanikrishna | last post: by
1 post views Thread by Pitmaster | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.