Slow inRetrieving data

briogene

I am developing an application and i have used the Dataset technology to retrieve data from the Database(SQL server 2000). The problem is that on loading some Forms that retrieve the data from the Database Via the dataset it takes too much time what could be the problem briogene

soni uma

Actually it is depend on the your page server controls. if you use Gridview than it is take time for loading. umesh

Colin Angus Mackay

briogene wrote:

The problem is that on loading some Forms that retrieve the data from the Database Via the dataset it takes too much time what could be the problem

There are a million and one things that could be the problem. But without a better description from you it makes it hard to us to diagnose. Some things to look at: How long does the query take to run in SQL Server itself? How much data is being transferred? What are you doing to it before the user gets to see it? Do you need a DataSet? Would a forward-only read-only view be more efficient?

Upcoming FREE developer events: * Glasgow: SQL Server Managed Objects AND Reporting Services ... My website

Colin Angus Mackay

soni uma wrote:

Actually it is depend on the your page server controls

It can depend on a lot more than that.

Upcoming FREE developer events: * Glasgow: SQL Server Managed Objects AND Reporting Services ... My website

soni uma

Yes It is Depend on the Many things like time taken by sql query,No of Records and Ect

Ian Uy

You can use Threads so the form will not lock up. :)

Colin Angus Mackay

Ian Uy wrote:

You can use Threads so the form will not lock up

That doesn't really solve the root problem.

Upcoming FREE developer events: * Glasgow: SQL Server Managed Objects AND Reporting Services ... My website