----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Soni Message 1 in Discussion 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 ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
