SQL Anywhere Mobile - Synchronization interval

Author

Synchronization interval

Alex Naumenko

2005-03-30, 9:43 am

Hi,

Could you advise how to make synchronization immediate (from client to
consolidated database and then from consolidated database to other clients).
It looks like with scheduled synchronization I can not setup synchronization
to run faster than every 1 min. It means, in worst scenario records between
2 remote databases will be in sync only in 2 mins.
How I can do it faster (within 10 secs,for example). I do not expect big
chunks of data synchronized, but I need synchronize small chunks of data
between remote databases close to real time.

Thank you,
Alex.

David Fishburn

2005-03-30, 9:43 am

"Alex Naumenko" <alex.naumenko@rogers.com> wrote in
news:423bac5a@forums
-2-dub of sybase.public.sqlanywhere.mobilink:

AN> Could you advise how to make synchronization immediate (from client
to
AN> consolidated database and then from consolidated database to other
AN> clients). It looks like with scheduled synchronization I can not
setup
AN> synchronization to run faster than every 1 min. It means, in worst
AN> scenario records between 2 remote databases will be in sync only in 2
AN> mins. How I can do it faster (within 10 secs,for example). I do not
AN> expect big chunks of data synchronized, but I need synchronize small
AN> chunks of data between remote databases close to real time.

Please ALWAYS include version and MORE importantly BUILD number
with EACH post (dbeng9 -v).

If you want finer control than 1 minute, you need to create a dbmlsync
hook procedure (and stop using a schedule):

CREATE PROCEDURE sp_hook_dbmlsync_del
ay()
BEGIN
UPDATE #hook_dict
SET value = 10
WHERE name = 'delay duration';
UPDATE #hook_dict
SET value = 10
WHERE name = 'maximum accumulated delay';
END;

You can read up in the help on what these do, further questions can be
answered here.

Have you looked into SIS (MobiLink Server Initiated Sync)? It will
handle the telling the other remotes they need to synchronize.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Sponsored Links