search

timeseries / qstudio

qStudio - Free SQL Analysis Tool
https://www.timestored.com/qstudio/
Apache License 2.0
420 stars 18 forks source link

Is kdb connection managed by connection pool? #16

Closed springmonster closed 8 months ago

springmonster commented 8 months ago

Hi, I saw the changelog mentioned, there's connection pooling.

Could you please help to share about kdb connection?

Is kdb connection managed by connection pool or there's separate socket open/close for each command?

Thanks very much!

image
ryanhamilton commented 8 months ago

Within qStudio the connection is not pooled and only one connection is used per server. This is why you can only send one query at a time in one qStudio instance (open more instances for multiples).

The release note you highlight was for sqlDashboards, a product that we bundled within qStudio. SqlDashboards was for displaying multiple real-time charts that updated simultaneously. That product is deprecated and no longer bundled as a separately runnable product within qStudio.

It has been replaced with Pulse: https://github.com/timestored/pulseui

FYI the query threading logic is here: https://github.com/timeseries/qstudio/blob/master/qstudio/src/main/java/com/timestored/qstudio/model/QueryManager.java#L173-L188

springmonster commented 8 months ago

Thank you so much for sharing so much!!! Really appreciate it!