JDBC Receiver performance

[Former Member]

Hi,

Some quick questions concerning JDBC Receiver performance.

1. I know you can increase the standard max 5 threads for the adapter. But want to understand if you set this ex. to 20 is this then the max for the JDBC adapter on the complete server or the max per server-node on the server? So, as an example, you have 1 server with 3 nodes and set the max threads to 20, is it then 20 for the server in total or per server-node (so 60 threads in total then)?

2. We have a scenario in which messages arrive in PI on ad-hoc basis and then are inserted into a non-sap applications database into 1 single table. This works fine, except that before each insert-statement there seems to be another query performed first in their database which takes 5-10 times longer than the actual insert of our message. This query checks the table-scheme of the table in which we insert each time. How can this be prevented/switched off?

Kind regards and thanks in advance for any tips/solutions,

Kurt

[marksmyth · Accepted solution]

Hello Kurt,

1. In this case, in theory, each server node will be able to process 20 messages in parallel from JDBC adapters. Thus, with 3 nodes, you will be able to process 60 messages in total.

2. I'm not sure!

Regards
Mark