What's the fastest way to transport a DataSet object?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 06 Oct 2004 00:39 GMT

I'm investigating ways to transfer DataSets to remote machines. Intuitively
it seems like using TCP/Binary would be faster than HTTP/SOAP, but since
DataSets are XML internally is there a way to gather the data from SQL-Server
and transport it as XML that might be faster than the TCP/Binary route?

Thanks.

Reply to this Message

J?lio Carvalho - 06 Oct 2004 18:12 GMT

..

I'm investigating ways to transfer DataSets to remote machines.
Intuitively
it seems like using TCP/Binary would be faster than HTTP/SOAP, but since
DataSets are XML internally is there a way to gather the data from
SQL-Server
and transport it as XML that might be faster than the TCP/Binary route?

Thanks.

..

If I understood well, I believe you wanted to say TCP/Binary = ".Net
Remoting" and HTTP/SOAP = "WebServices".
.Net Remoting is more faster, you will build applications server and
client, and register a channel TCP/IP to listen port, and all
serializable types can pass through it, including DataSet, DataTable.
You can also define a default xml structure, so you would send data
as string type using .Net remoting. This way you save space and reduce
traffic, but you may lose important DataSet informations.
I advise you use .Net Remoting with DataSet.

I hope this help you ...

Valew,

J?lio Carvalho
Programador C# .Net
julio.carvalho@gmail.com

Reply to this Message

Daniel Carbajal [MVP] - 06 Oct 2004 19:25 GMT

Maybe this is not what you want, but the fastest way to transport data is
not using DataSets, it is using your own classes with Byte arrays....
Regards,
Daniel Carbajal
MVP

> I'm investigating ways to transfer DataSets to remote machines. Intuitively
> it seems like using TCP/Binary would be faster than HTTP/SOAP, but since
> DataSets are XML internally is there a way to gather the data from SQL-Server
> and transport it as XML that might be faster than the TCP/Binary route?
>
> Thanks.

Reply to this Message

Mehdi Mirzaie - 07 Oct 2004 11:19 GMT

you can use 2 methods
a ) to get meta-data (schema of ur data) - GetXmlSchema of DataSet
b ) just data - GetXml of DataSet
or other ways like this.
TCP/Binary communication and formating with Window Service Host Process if
great .
If u use XML Entities instead of custom .Net classes , u can use benefits of
a loosly coupled system .but this is a trade-off for performance and
felxibilty .

> Maybe this is not what you want, but the fastest way to transport data is
> not using DataSets, it is using your own classes with Byte arrays....
[quoted text clipped - 10 lines]
> >
> > Thanks.

Reply to this Message

Saurabh Nandu - 08 Oct 2004 08:07 GMT

Hi,

if you are looking at a direct way to pass data from SQL in XML, then look
at the SQL Xml toolkit from Microsoft for MS SQL 2000.

[ http://www.microsoft.com/sql/techinfo/xml/ ]

Reply to this Message

What's the fastest way to transport a DataSet object?

Free Magazines