SqlDataAdapter.Fill method slow
First, make sure you are profiling the performance properly. For example, run the query twice from ADO.NET and see if the second time is much faster than the first time. This removes the overhead of waiting for the app to compile and the debugging infrastructure to ramp up. Next, check the default settings in ADO.NET … Read more