jonathanl-telenav opened a new issue #8007: URL: https://github.com/apache/pinot/issues/8007
The time to set up and tear down HTTP broker connections to execute queries has a negative impact on query latency. A simple connection pool could keep established connections alive for reuse. See c3p0 and dbcp for some details on connection pooling. This optimization should have no effect on threading or transactions. It's just a way of reusing a live connection instead of opening a new connection for each query from the client. The client and the broker would both need to be changed to make this work, as neither should close pooled connections that are live until they expire from lack of use. The discussion in Slack #general on January 12, 2022 gives more details. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org