HDB_NODEJS_THREADPOOL_SIZE not working

[david_brandow]

We are using HDB_NODEJS_THREADPOOL_SIZE attribute to increase worker threads in pool as per the recommendation for one of our nodeJS CAP module. Internally we use sap-cds to get a transaction and run the db queries against hana cloud.

It helped us run the DB queries against HC parallelly.

A year back, I tested this in my laptop and it was working for me in one of our nodeJS(CAP) module.

Recently I found the attribute has no effect and same I verified in my laptop.

Initially I though may be some new OS upgrade is blocking this.

As HDB_NODEJS_THREADPOOL_SIZE overrides UV_THREADPOOL_SIZE, I tested libuv’s non-blocking IO feature by utilizing UV_THREADPOOL_SIZE attribute with the help of a sample nodejs program and it worked(not with CAP).

Want to understand if any change at CAP side blocking this?

[david_brandow]

Can you confirm whether you, via CAP, are using the hdb driver or the @sap/hana-client driver? I ask because the HDB_NODEJS_THREADPOOL_SIZE variable only applies to the latter, not the former.

[Johan_sapbasis]

Hi,

Perhaps check this:

https://help.sap.com/docs/SAP_HANA_CLIENT/79ae9d3916b84356a89744c65793b924/22485d2937c4427fbbedefe3c...

Node.js Environment Variables

The new HDB_NODEJS_THREADPOOL_SIZE environment variable specifies the number of worker threads in the thread pool. The formerly used UV_THREADPOOL_SIZE environment variable is still respected, but is overridden by HDB_NODEJS_THREADPOOL_SIZE. If neither is set, a default value of 4 worker threads is used.

Kind Regards,

Johan