Speeding up the RDA Push and Pull

From: Karthik (karthik_at_scapevelocity.com)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 19:54:05 +0530

Hi All,

We have an existing Pocket PC 2002 application written in eVB 3.0 which uses
RDA Pull and Push to sync the data between the PPC and the Central Server.We
want to increase the speed of the Sync process as our target users find the
sync to be too slow with the dialup connections that they have.Does anyone
have any tips on speeding up the RDA Push and Pull either by compressing the
data or by any other way.We are also looking to use Merge Replication
instead of RDA.Do any of you know of the difference between RDA and Merge
Replication ,their advantages and what are the constraints each one
has.Thanks a lot for any help. 

-- 
Regards
Karthik
Disclaimer:
****************************************************************************
*******
Information contained in this E-MAIL being proprietary to Scape Velocity
Inc,
is 'privileged', 'confidential' and intended for use only by the individual
or entity to which
it is addressed. Any use or dissemination of any information contained in
the E-MAIL
beyond that necessary to conduct business with Scape Velocity Inc  is
strictly prohibited,
except as may be agreed to in writing between Scape Velocity and you or your
organization.
If the reader of this message is not the intended recipient or agent
responsible for delivering this
message to the intended recipient, you are hereby notified that any
dissemination,
distribution, or copying of this communication is prohibited. If you have
received
this communication in error, please notify us immediately and delete this
email.
****************************************************************************
*****

Relevant Pages

  • Re: Speeding up the RDA Push and Pull
    ... in the dial-up connection, the device, the IIS box or SQL Server. ... Try doing the sync on a device that has PPC 03 on it. ... Determine where the databsae and temporary database files are located. ... If you are doing large syncs with RDA, you might find better perofrmance by ...
    (microsoft.public.sqlserver.ce)
  • Re: Access Sync service
    ... I might look at RDA with Access, and it's great that I don't have to use IIS. ... The last option was Sync Services which I just downloaded. ... I'll go back and look at ADS and see if I can't read some more on it. ...
    (microsoft.public.sqlserver.ce)
  • Re: SQLCE RDA Push, Primary Key Conflict Problem
    ... You have to pull and push the PK of the table when using RDA. ... for uniqueness in your PK on the server. ... clients are incrementing that IDENTITY column at various times. ...
    (microsoft.public.sqlserver.ce)
  • Re: Windows Mobile 5 - what bacwards compatabiliy is there?
    ... Push is nice, but since I automatically poll my IMAP box every 15 minutes ... I also use Excel quite a bit, and never found Pocket Excel that limiting ... I used to sync my 2003 device a few times a day. ...
    (microsoft.public.pocketpc)
  • Re: rda and batching
    ... RDA is designed to allow a subscriber in a pub/sub model to ... you are trying to push data to ... a temp table on the server, you really aren't interested in "replication", ... > because i was returning data via more than one table it made the trigger ...
    (microsoft.public.sqlserver.ce)
Loading