sqldataadapter fill slow

  • Thread starter Thread starter incolsa
  • Start date Start date
I

incolsa

When i try to fill, it takes about 25 seconds, and the sql sentence in
the analyzer only takes 1 sec. The sentence returns 60 rows and 32
columns

sda.Fill(ds,"alojamientos");
tabla = ds.Tables["alojamientos"];

Anyone has the same problem ?
 
Incolsa,

That has to be a terrible difficult SQL statement that you use to retrieve
the data.
Retrieving 60 rows can be done invissible for a user.

What is the OS of the Server
What is the OS you are using
What is databaseServer are you using
What protocol are you using (OleDB, SQLClient etc).

Cor
 
Back
Top