You can LOAD DATA INFILE from a named pipe and dump the data into this pipe.
On Mon, Mar 23, 2009 at 11:22 AM, Andrej van der Zee
> > Sergei> Either by using the client API and prepared statements - then you
> > Sergei> need to convert your binary data to strings, and you can bulk-insert
> > 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.
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe: http://lists.mysql.com/internals?unsub=1