Re: Web service - Large dataset problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

Rather than passing a dataset, pass the string which results from

1) Writing the dataset to xml
2) Compressing the xml string
3) Base64Encodeing the compressed result.

You will discover that the amount of data passed over the wire is reduced by
86% which means, in your case, it is equivalent to sending just .14 * 300000
rows or just 42,000 rows.

Jim


<kasi.uh@xxxxxxxxx> wrote in message
news:1185223073.142593.138860@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I have a web service that is up and running. I query a central
database on the client side and pass the DataSet to the webservice. It
works fine for small datasets. When I try to call a webmethod on that
webservice for a large dataset (A table with 300,000 rows), I get the
following error message:
The underlying connection was closed: An unexpected error occurred on
a receive.
at
System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest
request)
at
System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest
request)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)

I have tried all those options in the KB page, none seem to work.
http://support.microsoft.com/kb/915599#top

Btw, am running VS2005 and IIS 6.0 on Win XP Pro. Thanks in advance!



.

Relevant Pages

  • Re: ASP.Net client sending XML string to remote .net web service
    ... There is a URL Behavior property of the WebService which defaults to ... Changing it to dynamic allows the Web Reference URL to be placed in ... > generate an xml string from a db and then send it to a web service on ... > the same box (client is part of the same service) which then processes ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Validating a DataSet passed to a Web Service
    ... Jan Tielens ... > want to check the size of DataSet or the whole request to the web service? ... > If it is whole request, you may get its size from its TotalBytes property; ... > work around, you may convert it to XML string with its WriteXML method, ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: Quickbooks functions
    ... The XML string must be in exactly the right configuration for the request (add ... You parse this response to check the error code. ...
    (comp.databases.ms-access)
  • RE: Validating a DataSet passed to a Web Service
    ... Thank you for using the community. ... want to check the size of DataSet or the whole request to the web service? ... you may get its size from its TotalBytes property; ... work around, you may convert it to XML string with its WriteXML method, and ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Calling Unmanaged .dll in webservice which works intermittently
    ... I have an ASP.NET 2.0 Webservice running on Windows server 2003. ... XML string and returns an XML string. ... get the old "Unable to load DLL" error. ...
    (microsoft.public.dotnet.framework.interop)