Hi, Thanks again for your answer. I decompiled the Reset methods and saw that it uses Clear internally. Probably I'll just move to .NET 1.1 and see what happens. The loading of the tables works nice so I do not have to Me.DACompanyContacts.Fill(ds.CompanyContacts) , just using it as I did works fine. Thanks again, Dan
Dan Bunea
Posts
-
DataSet Clear() performance problem -
DataSet Clear() performance problemHi, Thank you for your answer. The DataSet is bound to very many controls (about 50) so reinitializing it is not a solution, because I lose my bindings (of course during load they are suspended, throught their binding context). I have posted a more detailed explanation about this (with screenshots and code) at: http://www.geocities.com/danbunea/posts/DataSetClear.htm Could you tell me more about using Reset() because MSDN documentation doesn't seem to offer too much info. About ByRef you are right, I could have used ByVal. Thank you very much for your answer. Dan Dan
-
DataSet Clear() performance problemHi, Thanks for your answer. I will test it on 1.1 tomorrow to see. Dan
-
DataSet Clear() performance problemYes, 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
-
DataSet Clear() performance problemHi, 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
-
DataSet Clear() performance problemHi, 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
-
DataSet Clear() performance problemHi, 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