Hi Steve,
I'm afraid you have to expect a delay, moving such large datasets cross
machines. BTW, have you serialized the dataset to a file to see that it's
500K in size or is it an approximation? If it's just a guess, I wouldn't be
suprised if you find that it's much bigger in "reality".
Best Regards,
Jimmy
www.jnsk.se/weblog/
###
> We are experiencing some real time delays (several seconds) when information
> is transfered from a ES component to a GUI on the same computer....
[quoted text clipped - 17 lines]
>
> THANKS..... steve
Steve S. - 10 Jul 2003 21:23 GMT
YES... we did spool it out to a file (XML) and without
all the tag stuff, we estimated the size properly... as
the size estimates were taken off a row count and total
space per row... (OK, so there is some portion of
overhead associated with the table defination as part of
the collections, that doesn't explain that much of a
delay).
We took this a little further... and began to drop out
the uncontrolables.... like network delays... and data
access.... We simulated a DataSet/DataTable and filled
it with data like we would get from our database.. and
got similiar results....... so now we can send this
example to anyone... who can then replicate the situation
on their computer...
We also took this to the other end of the extreme... and
made a SINGLE CELL TABLE.. with all the information in it
that normally would be in an entire table... and without
ANY surprises... it took almost NO time... to marshal
the data back to the GUI...
So our issue appears to be... our system is serializing
the information into ASCII vs sending it binary (in a
dataset)...
FYI.... I am very familiar with the amount of delays to
expect when designing N-Tier systems across several
boxs... in-proc... out-proc... Server applications vs
libraries... been there... done that...
I just haven't seen this type of behaviour before... as
the .NET stuff is totally new... and there is some
behaviour differences that is not expected...
CODE IS AVAILABLE TO REPLICATE THIS... ALONG WITH
INSTRUCTIONS....
>-----Original Message-----
>Hi Steve,
[quoted text clipped - 33 lines]
>
>.
Jimmy Nilsson - 11 Jul 2003 22:52 GMT
Hi Steve,
OK, I think I get the picture. It would be interesting to look at the repro,
but I'm having vacation for the moment. Just cheating for five minutes now.
;-)
But I'm sure someone else can take a look.
Best Regards,
Jimmy
www.jnsk.se/weblog/
###
> YES... we did spool it out to a file (XML) and without
> all the tag stuff, we estimated the size properly... as
[quoted text clipped - 80 lines]
> >
> >.