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.

asked 04 Oct '12, 07:13

vhm's gravatar image

vhm
210131320
accept rate: 0%

retagged 05 Oct '12, 10:07

RussC_FromSAP's gravatar image

RussC_FromSAP
1.3k11030


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

  • Russ
permanent link

answered 04 Oct '12, 10:21

RussC_FromSAP's gravatar image

RussC_FromSAP
1.3k11030
accept rate: 18%

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×295
×75

question asked: 04 Oct '12, 07:13

question was seen: 906 times

last updated: 11 Oct '12, 05:55