Hi all
I have a form with some data bound to it. There is a list on the form that
could display any number of records that the user requests.
When changes are made to the data I use the GetChanges method to get a
temporary DataSet to pass the the Business Object layer, then when the
updates have been applied to the database I Merge and then AcceptChanges on
the main DataSet.
This is fine with small amounts of data, but when there are 30,000 records
the Merge and AcceptChanges takes a while to complete (to be more specific,
the Merge takes just over 1 second and the AcceptChanges takes just over 2
seconds), so when the user clicks on the Save button they are waiting for up
to 4 seconds. I know that this may not seem like a lot, and some peoples
response would be to not display a large amount of data in the first place,
but that is not something that is in my control.
Is there any way to speed up the process? Has anyone else found that the
Merge and AcceptChanges takes a while and used different data saving
techniques to get around it? If the user ony changes 1 field on 1 record,
they would not want to wait 4+ seconds to save it!
Kind Regards,
Steve