Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hey,

I've been digging through the documentation and have found under the "Mobilink tuning for performance" page (http://dcx.sap.com/index.html#sqla170/en/html/81ca8b316ce21014bc51f61aba9a022e.html) something confusing : "Mobilink uses pools of database worker threads (...) One pool is dedicated to reading upload (...) unpacking it. Another pool of threads, called database worker threads (...). Another pool of database worker threads is dedicated to packing and sending the download data (...)"

In my understanding, the threads that are dedicated to reading and unpacking are network threads ?

The -w option influences all the pools or only database working threads ?

In fine, when exactly is a database worker thread acquired ? In my understanding, the process would be :

  1. Receive and unpack upload
  2. Hold a database worker thread
  3. Apply upload
  4. Fetch download, put it in memory
  5. Release the database worker thread
  6. Send download

Not sure about the ordering of 5 and 6 though. Is that correct ?

asked 17 May '17, 07:40

yan's gravatar image

yan
806712
accept rate: 0%


The first sentence should just say "MobiLink uses pools of worker threads".

For more information, see https://wiki.scn.sap.com/wiki/display/SQLANY/Performance+and+Tuning+-+MobiLink

permanent link

answered 17 May '17, 10:33

Graham%20Hurst's gravatar image

Graham Hurst
2.7k11843
accept rate: 29%

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:

×371

question asked: 17 May '17, 07:40

question was seen: 3,309 times

last updated: 17 May '17, 10:33