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

  • Thread starter Thread starter Khanh
  • Start date Start date
K

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
 
Khanh said:
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!
Click to expand...

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?
 
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.
 
Back
Top