Sending data through webser vice is very slow

[Optimus]

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

 

[chris-s]

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