how to speed up to download data from SQL Server to SQLCE ?

[Khanh]

dear all,

In order to download data from SQL Server to SQL CE of my pocket PC,
our current model is StartDevice App -> WebService -> SQL Server. But
we have very big table with data is over 200,000 records (Product
Master), and by a very simple SQL statement "SELECT 10 fields FROM
ProductMaster", we must wait for over 3 hours to download to Pocket PC
!!! May anyone help me to optimize the downloading procedure ???
Can kind of RDA, Merge Replication solve this matter ? (note that we
only need 10 fields of 30 fields of ProductMaster).

Very appreciated!

Truong Khanh
Project Leader
FPT Software

 

[Jon Skeet [C# MVP]]

In order to download data from SQL Server to SQL CE of my pocket PC,
our current model is StartDevice App -> WebService -> SQL Server. But
we have very big table with data is over 200,000 records (Product
Master), and by a very simple SQL statement "SELECT 10 fields FROM
ProductMaster", we must wait for over 3 hours to download to Pocket PC
!!! May anyone help me to optimize the downloading procedure ???
Can kind of RDA, Merge Replication solve this matter ? (note that we
only need 10 fields of 30 fields of ProductMaster).

Very appreciated!

I think the first thing you should work out is where the time is going.
Is it in the network bandwidth, in the insert into the SQL CE database,
at the SQL server itself?

 

[Alex Feinman [MVP]]

RDA is probably the fastest option.

 

[chora]

RDA is very fast, compresses data and you can select any columns and
filter rows. It is the best solution for the initial download and for
tables that do not change often.

Another way is to try and compress the dataset you are sending with Web
Service.

Merge replication is hard to setup and maintain and may be is not what
you want to do in this case.