DataSet Clear() performance problem
-
Hi, I am developing a Windows.Forms app. I am using a multi tier architecture with databinded strongly typed datasets . I am using a data access component called Facade where I have a method: public Sub LoadCompany(ByVal companyID as Integer, ByRef ds as CompaniesDataSet) ds.Clear() ...code to set the parameter in the select command DACompanies.Fill(ds) End Sub It seems that ds.Clear() takes more and more time to complete , from a few miliseconds at start to 4-5 seconds after 100 method invokes. Anyone has an answer to this? Thank you, Dan Bunea
-
Hi, I am developing a Windows.Forms app. I am using a multi tier architecture with databinded strongly typed datasets . I am using a data access component called Facade where I have a method: public Sub LoadCompany(ByVal companyID as Integer, ByRef ds as CompaniesDataSet) ds.Clear() ...code to set the parameter in the select command DACompanies.Fill(ds) End Sub It seems that ds.Clear() takes more and more time to complete , from a few miliseconds at start to 4-5 seconds after 100 method invokes. Anyone has an answer to this? Thank you, Dan Bunea
-
-
Yes, I saw that too. Unfortunately, I cannot use that simple solution, because I have very numerous bindings made to my DataSet. Any other solution? Thank you for your reply, Dan
Since this seems to be a .NET Framework issue, I do not see how you can alter this behaviour without changing the structure of your code. Also, I do not know if this issue only arises on .NET v1.0 or not. You should check that, because .NET v1.1 had many perfomance and bug related improvements
-
Since this seems to be a .NET Framework issue, I do not see how you can alter this behaviour without changing the structure of your code. Also, I do not know if this issue only arises on .NET v1.0 or not. You should check that, because .NET v1.1 had many perfomance and bug related improvements