Replies: 1 comment 1 reply
-
Hi @t0k4rt Did you check the insert time without the async insert? Do you need wait for query? You might want to get familiar with a documentation around async insert: https://clickhouse.com/docs/en/cloud/bestpractices/asynchronous-inserts |
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Dear community,
We are considering using clickhouse at our company but found very strange and slow ingestion rate.
I cannot get past around 17 inserts per seconds using asyncInserts with wait enabled (as
advised in clickhouse documentation).
When trying async insert example (slightly modified):
Connection options are:
Server and client versions:
ClickHouse client version 24.9.1.3278 (official build).
Connected to ClickHouse server version 24.9.1.
I get a rather constant 60ms time per inserts on my dev machine.
I tried also on a dedicated server with the same behaviour and timings.
Is this normal ?
Should Async insert be avoided in favor of another method ?
Thanks for your help
Beta Was this translation helpful? Give feedback.
All reactions