Re: High speed writing(INSERT) can significantly reduce SQL query performance

[Pavel Tupitsyn]

- Try changing QueryThreadPoolSize [1]
- Consider Data Streamer [2] for high-volume data insertion instead of SQL

[1]
https://ignite.apache.org/docs/latest/perf-and-troubleshooting/thread-pools-tuning#queries-pool
[2] https://ignite.apache.org/docs/latest/data-streaming

On Fri, Aug 9, 2024 at 3:16 AM 38797715 <38797...@qq.com> wrote:

> Hi team,
>
> When performing high-speed writes(INSERT statement), it can lead to a
> significant decrease in SQL query performance, the execution time will be
> extended by tens of times.
>
> We are using the H2 SQL engine, Ignite 2.16.0. We know that Ignite uses
> different thread pools for writing and querying.
>
> May I ask if this is a known issue? Or are there any parameters that can
> optimize the performance of this scenario?
>