Re: remote binary bulk inserts from background thread in MySQL server

[Andrej van der Zee]

Hi,


>
> Sergei> Either by using the client API and prepared statements - then you won't
> Sergei> need to convert your binary data to strings, and you can bulk-insert many
> Sergei> rows at once.
>
> At this moment, the fastest way to do it is to write things to a file
> on the client side and then issue a 'load data local infile' to read
> the file.

Wouldn't writing it to disk first slow down the whole thing? Writing
directly to the network wouldn't have this overhead.

Thanks,
Andrej