Hi ,
I have a performance related issue which I hope you can help me out
with.

Here it is .
Environment:
VS 2005 Beta 2
SQL Server 2005 Beta 2
Winforms on XP

Architecture:
Distributed architecture with .NET remoting.
Application server with a console server as a host to the remote
object. (Single call, TCP)
Database server
Client


Issue 1:
a. Load large data in a datagridview:
We have a table with currently 10 lakh records.
We are loading a dataset (with about 1 lakh records) and binding it to
the datagrid view. This is currently taking about 30 seconds. How can
we improve the loading time. We are using a SP.
b. What is the best way to update any changes/additions in the grid
back to the DB?
Currently we are calling the RemoteObject.Save method where we are
i. creating a dataadapter
ii. Executing the Select query again
iii. Do the adapter.update
We then load the grid again to avoid data concurrency errors of newly
added rows.
How do we optimize this scenario?
The whole Save method now takes about a minute.

Issue 2:
Loading the TreeView:
The data that we are talking about is a hierarchical data. We are
generating the tree View to display the same 1 lakh records. One way is
to display only the initial nodes and then on click of each node, get
the child nodes. But in our scenario we cannot do this for other
reasons.
We have to generate all the nodes. This is currently taking about 20
seconds for a record count of 30,000.
WE found an article which talked about using the TreeNodeCollection
class but unfortunately the treenodecollection class does not have a
constructor in WinForms. It does have the same in Webforms.
We are currently generating the TreeView by using the FullPath property
(this has actually improved the load time from almost a minute to the
current 20 odd seconds).

How do we optimize this?

Thanks in advance,
Soni