Hi Team, we are seeing a major performance issue on a spring boot application which queries pinot through pinot jdbc connectivity. The api RPS is expected to ~150 with less than 1 sec response time. Do we need to implement Hikari CP to mitigate the performance issues ? From the pinot brokers we see that response times are less than 1 sec. Can you please help ? CC: @Mayank

Can you identify the bottleneck?Bis the client in the same network, is there vpn in between?

@Mayank Rite now, we are going to get thread dump to see what is going wrong in the application side. At the same time we are suspecting whether pinot brokers are making the thread to wait. Yes. It is in the same network.

Can you use the rest-api to launch a workload using locust or similar tool, to eliminate JDBC

@Mayank, This is the production application, Changing from jdbc to rest api will be a significant effort. So, just to confirm on the behavior of JDBC, does it behave like a traditional jdbc ? is that the reason to switch to rest ?

No I am asking to test to see if the bottleneck is jdbc

Ok.