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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dataadapter.fill slow 2
How to bind a label to a dataset with C# 4
Error Message :-Update requires a valid InsertCommand when passed DataRow collection with new rows. 0
Binding a column to a dropdownlist at runtim 2
SQL Server Query Analyzer faster than ADO.Net SQL Data Provider 2
Doubt creating a class/function? 5
about understanding 4
SqlDataAdapter Fill Dataset is slow 6

Back
Top