importing data into a sqlce20 database

[Milsnips]

hi there,

i've got an app that imports roughly 10000-15000 records of master data
which needs to be sync'd daily. Currently i'm using WLAN or GPRS to connect
to remote SQL database, then get a populate a sqlDataReader and as i loop
through remote data, i insert it into local.

This can take up to 6-10 minutes which i was wondering if its possible i can
speed this up. i've looked into replication and find it a bit complicated in
having to configure it for each customer rollout i do.

Any advice on speeding up the data import would be appreciated.

thanks,
Paul

 

[Ginny Caughey [MVP]]

Paul,

You might check out the products at http://www.primeworks-mobile.com/. I
don't know if that would be faster, but I suspect that it might.

If you could upgrade from SqlCE 2.0 to SQL Mobile, of course you could
massage the data on the desktop machine and just copy the SDF file to/from
the device, and that would be faster.

 

[Milsnips]

yep good point, thanks for the advice. I also considered the option of
generating the file on desktop, compressing and sending to device, i think
it could be faster.

Will also have a look at the link you sent too to see if it helps out.
thanks,

Paul

 

[Ginny Caughey [MVP]]

Paul,

SQL Mobile, aka SQL Server Everywhere, and now named SQL Server Compact
Edition will be even faster on the desktop in the next version:
http://blogs.msdn.com/stevelasker/a...-server-everywhere-gets-yet-another-name.aspx
The optimizations for insert performance on the desktop will really make a
difference for scenarios where you're building a database on the desktop.