cancel
Showing results for 
Search instead for 
Did you mean: 

Database worker thread : when and what ?

Former Member
0 Kudos
3,503

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 ?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

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

Answers (0)