|
Hi we have POS System which is using Mobilink (ver 9.X) to synchronize the data to console server ( Sybase ASE ver 12.5) . user complained that the POS system hangs( freeze application screen) intermittently . we did a test and found that the screen freezes while user settled transaction and at the sametime mobilink client waiting for apply upload to console server . is there any suggestion to improve this situation. Thanks. |
|
If your remotes are SQL Anywhere, consider using transactional uploads (this link is for v10, but the option should behave in much the same way, if not identically). It will only help if your remote used many transactions to make the upload. There will be no benefit if the upload represents a single transaction from the remote. While the upload, and hence the sync, may take longer, being many transactions instead of one, the contention in your consolidated database will be reduced. Note that later versions of MobiLink support a server-side switch for grouping transactional uploads into larger transactions, allowing you to tune the consolidated-side performance without a client-side change (assuming they are already using transactional uploads).
Thanks for the recommendation. do I still need to schedule the sync interval to synchronize or the -tu will sync by transaction?
(08 Oct '12, 05:48)
vhm
Replies hidden
Transactional uploads should work whatever the schedule. If you are using a schedule now, I expect you should continue to use one with -tu.
(09 Oct '12, 09:42)
RussC_FromSAP
Just to clarify: "Transactional uploads" doesn't mean each transaction is "automatically" sync'ed against the consolidated database. Synchronization does simply just happen at the same schedule or events it woud without transactional uploads.
(09 Oct '12, 10:00)
Volker Barth
Thanks for the clarification..
(11 Oct '12, 05:55)
vhm
|