How to...

  • Thread starter Thread starter Jacek Jurkowski
  • Start date Start date
J

Jacek Jurkowski

.... speed up Fill() method of SqlDataAdapter?
It's very slow. I'm just executing 'sp_tables'
procedure on SqlServer and the performance
is poor ...
 
... speed up Fill() method of SqlDataAdapter?
It's very slow. I'm just executing 'sp_tables'
procedure on SqlServer and the performance
is poor ...
Click to expand...

#define slow :). The Fill() method is pretty fast. It has more
overhead than if you use a DataReader, but not that much. The sp_tables
stored proc shouldn't be that slow either, but it of course depends on your
sqlserver config and catalog config.

When you execute the sp_tables stored proc in query analyzer on the
same catalog, does it perform fast? And how many rows are returned?

FB
 
Hi Jacek,

I agree with Frans that SqlDataAdapter.Fill method is not a low performance
method. Have you tried Frans's suggestion?

Please feel free to feedback. Thanks

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
Back
Top