Re: Sending data through webser vice is very slow




Optimus wrote:
Hi,

I'm developping an application in Pocket PC/.net CF 2.0
to send approximately 1000 records using a web service.
And, I pass a dataset as its argument so that
it can be used to insert all the records to my SQL Server database.

My problem is it is very slow to transfer the data as a dataset,
which take approximately 7-8 miniutes every time.
In addition, sometimes it cause the application failed to send the data
as a whole.
So I guess that the data is probably too large for sending it over my
VPN network.

I'm almost desperate to get work around with this.
Is there any way to compress the data before sending its in
.net compact framework?

Any help is greatly appriciated!!!
Steve

Whilst the technique you are using is very simple to implement, it
comes at a price, and that is efficiency!

What you will find is that the dataset is effectively converted into an
XML representation and then the 'text' transmitted, sounds great, but
in practice with all the XML tagging the volume of data involved
increases.

I've seen references to implementing some form of compression on IIS,
but don't know how practical this really is to implement.

Other approaches would be :

.. review the volume/size of datasets and data that you really need to
send

.. concatenate all the fields into a single delimited string and write a
new web method to accept this data, you could even 'zip' it up.

.. if you are using SQL Server CE, look at using 'RDA'

Chris

.



Relevant Pages

  • Re: String compression
    ... something that was basically a web service. ... We did it by building the XML message, zipping it, then base64 encoding the ... Then we embedded that base64-encoded string inside of a very simple ... In those days we had to compress to file and then operate on the file. ...
    (microsoft.public.dotnet.languages.csharp)
  • IIS and GZip compression for web service soap responses
    ... I have tested gzip and it seems to work fine for static ... But IIS just dont want to compress my web service responses. ...
    (microsoft.public.inetserver.iis)
  • Re: String compression
    ... Of course you can only compress the ... as I am not aware of any Web Service extension allowing compressed SOAP ... Dmitriy Lapshin [C# / .NET MVP] ... > I'm looking for code on how to compress a string to send through a ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: XML Encrypting/ Compression
    ... the server would use WSE 2.0 and the client would use the CF WSE bits. ... i dont know of any Web Service compression specification yet. ... Does anyone know of a tool that can compress, encrypt and encode the xml so ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: ADODB.Recordset as parm to Web Service
    ... dkrishnan at geniant dot com ... > it's XML representation can be passed as a parameter to a Web Service? ... > in my app that I need to pass as a parameter to the Web Service. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)