uchenily opened a new pull request, #44:
URL: https://github.com/apache/doris-mcp-server/pull/44

   This PR introduces a `DorisSessionCache` to cache and reuse 
`DorisConnection` objects in memory. This helps to reduce the overhead of 
creating new connections, especially for frequently used system sessions like 
"query" and "system", and avoid not calling release_connection leads to 
`Connection acquisition timed out` when the number of connection pools reaches 
the maximum value.
   
   The PR #34 fixed the issue when calling the tool `exec_query`, but in the 
codebase, a large number of other tools directly using get_connection ("query") 
to get connection object but without calling the release_connection method will 
cause the connection fail to be obtained after a certain number of times.
   
   Key changes:
   - Added `DorisSessionCache` class to manage the lifecycle of cached sessions.
   - The cache is configurable to store system sessions, user sessions, or 
both. By default, only system sessions are cached.


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to