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
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