News for hackers. Stuff that matters.

A comment on Ask HN: Suitable database to store web analytics data for million insertion. Parent comment

Re:Ask HN: Suitable database to store web analytics data for... by richraposa on Saturday April 15, 2023 @10:37AM (#35580987)
ingestion of these events during peaks at 500k events per minute. You can't ingest them individually into Clickhouse or most other databases.

Turn on async_insert or use a Buffer table engine and you can easily insert them individually into ClickHouse

[ Parent | on HN ]
Re:Ask HN: Suitable database to store web analytics data for... by iknownothow on Sunday April 16, 2023 @12:55PM (#35591733)
That's interesting! I don't have much experience with Clickhouse, especially not in the last two years. I'll have to try this out myself. That's a pretty incredible if it can handle batching internally.
[ Parent | on HN ]