"Milsnips" <milsnips@hotmail.com> wrote in message
news:eQuGehM$GHA.1784@TK2MSFTNGP04.phx.gbl...
> 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
>

"Milsnips" <milsnips@hotmail.com> wrote in message
news:OqcyQTa$GHA.3928@TK2MSFTNGP03.phx.gbl...
> 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]" <ginny.caughey.online@wasteworks.com> wrote in
> message news:eOeyQZQ$GHA.2180@TK2MSFTNGP05.phx.gbl...
>> 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.
>>
>> --
>> Ginny Caughey
>> Device Application Development MVP
>>
>>
>> "Milsnips" <milsnips@hotmail.com> wrote in message
>> news:eQuGehM$GHA.1784@TK2MSFTNGP04.phx.gbl...
>>> 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]" <ginny.caughey.online@wasteworks.com> wrote in message
news:eOeyQZQ$GHA.2180@TK2MSFTNGP05.phx.gbl...
> 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.
>
> --
> Ginny Caughey
> Device Application Development MVP
>
>
> "Milsnips" <milsnips@hotmail.com> wrote in message
> news:eQuGehM$GHA.1784@TK2MSFTNGP04.phx.gbl...
>> 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
>>
>
>