WCF Performance Issue

[MikeTI]

Jan 8, 2009

Happy new year.

(Using VB Net 2008, SQL 2008)

I have built a winform application that uses WCF.

Now I am sending a query that retruns a DataSet from the WCF. I have seen
that the performance is not good if the DataSet is large.

Request Advise on:

1. What is the best and fastest way to retrieve data through WCF.
2. Is there a way to compact a DataSet for transfer, if a DataSet is used.
3. I am using basicHttpBinding. I have seen reference of NetTCPBinding in
internet indicating that it uses binary instead of text transfers. If yes,
can someone please point me to some good examples as I am a novice. Also I
am using Windows Vista Home Premium, can I test NetTCPBinding on it or do I
have to use ISS version 7.

Thank you.

Regards
MikeTI

 

[Mr. Arnold]

Jan 8, 2009

Happy new year.

(Using VB Net 2008, SQL 2008)

I have built a winform application that uses WCF.

Now I am sending a query that retruns a DataSet from the WCF. I have seen
that the performance is not good if the DataSet is large.

Request Advise on:

1. What is the best and fastest way to retrieve data through WCF.
2. Is there a way to compact a DataSet for transfer, if a DataSet is used.
3. I am using basicHttpBinding. I have seen reference of NetTCPBinding in
internet indicating that it uses binary instead of text transfers. If yes,
can someone please point me to some good examples as I am a novice. Also I
am using Windows Vista Home Premium, can I test NetTCPBinding on it or do I
have to use ISS version 7.

Thank you.

Regards
MikeTI

I responded to you in the Web service NG.

 

[Cor Ligthert[MVP]]

Mike,

It should not make any difference if you use WCF or whatever.

Did you try it already in SQL Server Manager Studio

Cor