Dino Esposito has an article in the latest MSDN (http://msdn.microsoft.com/msdnmag/issues/05/08/CuttingEdge/default.aspx) that discusses performance of passing serialized datasets. It's geared towards WebServices; but, it would still apply to remote objects.
He also makes reference to "Returning DataSets from WebServices is the Spawn of Satan and Represents All That Is Truly Evil in the World" (http://www.hanselman.com/blog/ReturningDataSetsFromWebServicesIsTheSpawnOf SatanAndRepresentsAllThatIsTrulyEvilInTheWorld.aspx). I get the impression from the articles that using a collection instead of a dataset is the way to go. On Wed, 5 Oct 2005 16:01:23 +0200, Ryan Heath <[EMAIL PROTECTED]> wrote: >+ 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® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
