how to boost insert select from remote table

[674345386]

hi, when i run query :

insert into db.tb1_local select * from remote ('11.60.#.#',db.tb1_local,'username','passwd') where partition_col = '2021-10-10 23:00:00' SETTINGS max_execution_time=650,max_insert_threads=300,max_threads=300;

it took almost : Elapsed: 482.117 sec. Processed 17.26 million rows, 228.62 GB (35.80 thousand rows/s., 474.19 MB/s.)
500sec ,
it looks like it was a little bit slow than the common INSERT ,
how can i boost this INSERT SELECT FROM REMOTE ?

thx ~

[den-crane]

35.80 thousand rows/s., 474.19 MB/s.

35.80 thousand rows/s., 474.19 MB/s. ~ 13kb row. It kinda wide rows.

474.19 MB/s -- Check the network bandwidth, 474.19 MB/s * 8 ~ 4 Gbit/s
Clickhouse does not compress data for remote queries. You may limited by a network.