Title
#users-public
a

Ajay Pilaniya

10/31/2022, 1:23 PM
Hi Everyone.. We at our organization are doing some research regarding different time series databases. Earlier we used to store our data on Elasticsearch but now our data is growing every day and we need a database which can handle this growing dataset. We have already discarded timescale due to high latency in Distinct count queries. We have setup quest db today and will ingest some random data points and will run some queries later. One thing that I am struggling with is that we use Hibernate JPA in our Java application. In QuestDB I am unable to insert datapoints using multiple threads. When more than one thread tries to access the data we get the error that
Table is busy
. Is there any workaround this? I know that I can use ILP but I am not familiar with it and was trying to avoid this.
Jaromir Hamala

Jaromir Hamala

10/31/2022, 1:36 PM
Hello Ajay, for now the only workaround is to retry the query. I guess that’s not something Hibernate can do easily. Unless it allows pluggable error handling strategies? I’m not sure here. We are working on a Write-Ahead Log mode for tables then that should allow inserts from multiple threads. ILP is indeed the way for high-throughput ingestion.
a

Ajay Pilaniya

10/31/2022, 1:38 PM
@Jaromir Hamala In ILP documentation I am seeing an auth token parameter. How do I get this? In Hibernate I am only supplying username and password.
Jaromir Hamala

Jaromir Hamala

10/31/2022, 1:39 PM
there is no auth unless you enabled it explicitly on a server. if you are just trying things then you can omit it completely. later you can enable it.
a

Ajay Pilaniya

10/31/2022, 1:42 PM
But I have username and passwords for the server. Should I remove those also?
Jaromir Hamala

Jaromir Hamala

10/31/2022, 2:09 PM
yes. I assume the username&password you have are for the Postgres connector. The Postgres connector uses a username&password by default. ILP does not.
a

Ajay Pilaniya

10/31/2022, 2:10 PM
Ok thank you.. Although I am seeing good performance in insertions even on single thread so for my basic use case it should suffice.