List:Internals« Previous MessageNext Message »
From:Andrej van der Zee Date:March 23 2009 10:22am
Subject:Re: remote binary bulk inserts from background thread in MySQL server
View as plain text  
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
Thread
remote binary bulk inserts from background thread in MySQL serverAndrej van der Zee5 Mar
  • Re: remote binary bulk inserts from background thread in MySQLserverSergei Golubchik6 Mar
    • Re: remote binary bulk inserts from background thread in MySQLserverMichael Widenius8 Mar
      • Re: remote binary bulk inserts from background thread in MySQL serverAndrej van der Zee23 Mar
        • Re: remote binary bulk inserts from background thread in MySQL serverSela Lerer23 Mar