DataSet Clear() performance problem
Visual Basic
1
Posts
1
Posters
0
Views
1
Watching
-
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