Also please see Improving DataSet Serialization and Remoting Performance http://support.microsoft.com/default.aspx?scid=kb;en-us;829740
-----Original Message----- From: Unmoderated discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Heath Sent: Wednesday, October 05, 2005 10:01 AM To: [email protected] Subject: Re: [ADVANCED-DOTNET] Remoting speed + dataset version 1.1 serialize its parts to xml although you would have specified to serialize it binary... // Ryan On 10/5/05, Peter Ritchie <[EMAIL PROTECTED]> wrote: > What's the data source? Are you getting one record at a time from the > remote object; or are you receiving a dataset object? How big is each record? > > An extra 30 seconds for remoting doesn't seem all that bad. If you're > passing a dataset object over the wire (I'm assuming you are), it might be a > bit on the high side. If you're sending 1 record at a time, quite > respectable. If your DBMS is communicating over TCP as well, it's using the > same bandwidth that your remote object is and you're performance will be > coupled to that. > > I don't know what the expected throughput of TCP is when not going over the > wire; but, it still goes through the stack so it's still coupled to the > throughput of data going over the wire. If you yanked your cables you might > see a bit of an improvement. > > If you're concerned that 30 seconds is a bit high, you could using something > like Ethereal to see what is actually being sent and tweak the design, if > you can. > > On Tue, 4 Oct 2005 19:12:23 -0500, Franklin Gray > <[EMAIL PROTECTED]> wrote: > > >using TCP, binary and port 999, I've been experiencing data loading speeds > >7 times slower. Does that sound about right? > > > > > >Details: > > > >I read 30,000 records into a datatable when the remoted object get created > >(just once....singleton). > > > >When I open the form with the grid on it, I call the remoted object to get > >a copy of the dataset and load that copy into the grid. > > > >To cut out the network, I ran both the client and server objects on the > >same machine. > > > >If I run without remoting, the loading of data takes 4-5 seconds. If I > >run with remoting, it takes the loading of the data 35 seconds. > > > > > >NOTE: it is a slow machine but the customer has slow machines too so that > >is why I am using it. > > > >NOTE: Yes, I know...who in their right mind wants 30,000 records on a > >form....my customer does so I can't argue with that. > > > >=================================== > >This list is hosted by DevelopMentor(r) http://www.develop.com > > > >View archives and manage your subscription(s) at http://discuss.develop.com > =================================== > This list is hosted by DevelopMentor(r) http://www.develop.com > > View archives and manage your subscription(s) at http://discuss.develop.com > =================================== This list is hosted by DevelopMentor(r) http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
