"Jacek Jurkowski" <jj********@datacomp.szczecin.pl> wrote in
news:u0**************@TK2MSFTNGP10.phx.gbl:
... speed up Fill() method of SqlDataAdapter?
It's very slow. I'm just executing 'sp_tables'
procedure on SqlServer and the performance
is poor ...
#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
--
Get LLBLGen Pro, the new O/R mapper for .NET:
http://www.llblgen.com
My .NET Blog:
http://weblogs.asp.net/fbouma
Microsoft C# MVP