WCF Performance Issue

  • Thread starter Thread starter MikeTI
  • Start date Start date
M

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
 
MikeTI said:
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
Click to expand...
I responded to you in the Web service NG.
 
Mike,

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

Did you try it already in SQL Server Manager Studio

Cor
 
Back
Top