C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...




Forums » .NET » WCF »

Passing large dataset through wcf service


Posted Date: 09 Oct 2009      Posted By: satish      Member Level: Bronze     Points: 1   Responses: 1



Hi frieds,

I have created WCF service application from where I am returning a dataset having more than 50000 rows and 25 columns. When I request the data from the WCf service it requires about 5000 ms to get the dataset. The time required for to create dataset in service is less than 400 ms. about 4600 ms required to transfer data across WCF service boundry to client application.
I am using NetTcpBinding for the WCf service.
Anyone has any idea how can I improve the performance of WCF service?

Thanks in advance.

Regards,
Satish Jadhav.



Responses
Author: Anand Ranganathan    16 Oct 2009Member Level: BronzeRating: 2 out of 52 out of 5     Points: 2

Yes, you can fast remote a large dataset!

There is a SDK for you to exchange large dataset with a latency less than 100 ms between client and server if you can remoting IDataReader

See the following article for fast remoting IDataReader, DataTable and DataSet.


http://www.udaparts.com/document/articles/rado.htm

With that said, you might want to rethink this idea of sending a big dataset over the wire.

Cheers!
Anand
Anand R


Post Reply
You must Sign In to post a response.
Next : Debug wcf service
Previous : Wcf - report generation
Return to Discussion Forum
Post New Message
Category: WCF

Related Messages


dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use