Bulk insert optimization #9

New issue

Open

opened 2026-09-08 06:46:10 +02:00 by c.fahner · 0 comments

c.fahner commented

2026-09-08 06:46:10 +02:00

Owner

Currently all documents passed to the insert command are inserted one by one, while there are faster ways to insert multiple documents at once.

Batching inserts per 1k rows seems to be optimal.

Currently all documents passed to the insert command are inserted one by one, while there are [faster ways](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/how-to-quickly-insert-data-into-mariadb) to insert multiple documents at once. Batching inserts per 1k rows seems to be optimal.

c.fahner added the

enhancement

label

2026-09-08 06:46:10 +02:00