sqldataadapter fill slow

[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 ?

[Cor Ligthert [MVP]]

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

<in*****@leveltelecom.es> schreef in bericht
news:11**********************@u72g2000cwu.googlegr oups.com...

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 ?