G
Guest
Hi All
I'm just coming up to speed here on .NET and have a C# WinForm App that accesses a database. I've gotta form with the following code in the form_load event
private void DocumentsDetail_Load(object sender, System.EventArgs e
this.dsDocuments1.Clear()
this.daDocuments.Fill(this.dsDocuments1.Documents_Sel)
The DataAdapter is using Stored Procedures and I'm seeing dismal performance on my local development machine. To bring the form up _without_ the above code, it displays in under 1 second. Add the above code and it takes a little over 4 seconds to bring it all up with the data being displayed
This particular stored procedure is simply a 'Select * from Documents'. Table only contains 3 records and should not have more than 150 records, so not worried about the star. Number of columns is around 15 or so
Machine isn't latest and greatest, but certainly not a dog either
Is this a typical response time and so should just get used to this, or more a pilot error? Appreciate any comments on this - this just really seems very slow to me and I'm concerned
Thanks...Bo
I'm just coming up to speed here on .NET and have a C# WinForm App that accesses a database. I've gotta form with the following code in the form_load event
private void DocumentsDetail_Load(object sender, System.EventArgs e
this.dsDocuments1.Clear()
this.daDocuments.Fill(this.dsDocuments1.Documents_Sel)
The DataAdapter is using Stored Procedures and I'm seeing dismal performance on my local development machine. To bring the form up _without_ the above code, it displays in under 1 second. Add the above code and it takes a little over 4 seconds to bring it all up with the data being displayed
This particular stored procedure is simply a 'Select * from Documents'. Table only contains 3 records and should not have more than 150 records, so not worried about the star. Number of columns is around 15 or so
Machine isn't latest and greatest, but certainly not a dog either
Is this a typical response time and so should just get used to this, or more a pilot error? Appreciate any comments on this - this just really seems very slow to me and I'm concerned
Thanks...Bo