SQL Anywhere Mobile - synchronization problem

Author

synchronization problem

adosun

2005-10-27, 8:20 am

Hi there,
I have a synchronization problem with synchronizing two ASA
databases. I have to synchronize some tables (download
only), and one of the table will have big amount of data to
synchronize (about 150.000 =96 300.000 rows ). The
synchronization process takes forever.

As far as I understood, the mobilink server works as
follows:
1. gathers all the data that will be sent to the remote
database
2. sends all these data to the remote server at once
3. the remote database struggles to add these data

When the first step occurs, the processor goes up to 100%
and stays there till the data gathering finishes. This
happens when only one remote database synchronizes, what
will happen when several remote databases will try to
synchronize with the consolidated database?

Now, the questions:
It is the above description correct?
There are some wais to optimize this synchronization?

Thanks all,
AdoSun

Breck Carter [TeamSybase]

2005-10-27, 8:20 am

What is "forever"? How long does it take, and how fast do you want it
to be?

What kind of hardware are you using? What kind of connection? E.g.,
are you are talking about a Palm device and HotSync, or a 3Ghz remote
computer and a 100Mbit network connection?

Do you need to download this much on every synchronization, or just
the first synchronization?

Breck

On 5 Oct 2005 02:25:23 -0700, adosun wrote:

>Hi there,
>I have a synchronization problem with synchronizing two ASA
>databases. I have to synchronize some tables (download
>only), and one of the table will have big amount of data to
>synchronize (about 150.000 – 300.000 rows ). The
>synchronization process takes forever.
>
>As far as I understood, the mobilink server works as
>follows:
>1. gathers all the data that will be sent to the remote
>database
>2. sends all these data to the remote server at once
>3. the remote database struggles to add these data
>
>When the first step occurs, the processor goes up to 100%
>and stays there till the data gathering finishes. This
>happens when only one remote database synchronizes, what
>will happen when several remote databases will try to
>synchronize with the consolidated database?
>
>Now, the questions:
>It is the above description correct?
>There are some wais to optimize this synchronization?
>
>
>Thanks all,
>AdoSun

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

AdoSun

2005-10-27, 8:20 am

The remote machine is a desktop machine 3.4 GHz, 1 GB
memory. I'm trying on test environment; the connection is on
local network 100Mbps.
The amount of synchronization data could be that much not
only on the first time.
One of my concerns is that the processor, from machine where
the consolidated database resides, is used 100% by the
mobilink process, for only one connection.
To download 150.000 rows, the synchronization takes more
then 1.5 hours, this is way too much, even if there are
150.000 rows (and could be more).

> What is "forever"? How long does it take, and how fast do
> you want it to be?
>
> What kind of hardware are you using? What kind of
> connection? E.g., are you are talking about a Palm device
> and HotSync, or a 3Ghz remote computer and a 100Mbit
> network connection?
>
> Do you need to download this much on every synchronization
> , or just the first synchronization?
>
> Breck
>
> On 5 Oct 2005 02:25:23 -0700, adosun wrote:
>
> ASA >databases. I have to synchronize some tables
> (download >only), and one of the table will have big
> amount of data to >synchronize (about 150.000 =96 300.000
> rows ). The >synchronization process takes forever.
> remote >database
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
>
http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

Greg Fenton

2005-10-27, 8:20 am

AdoSun wrote:
> To download 150.000 rows, the synchronization takes more
> then 1.5 hours, this is way too much, even if there are
> 150.000 rows (and could be more).

Use the MobiLink Monitor (or verbose console output) to determine which
events are taking the most time, and from that determine why the
consolidated is taking so long to process that script.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links