At 10:30 AM 6/5/2008, you wrote:
Simon,
In my experience load data infile is a lot faster than a sql file htrough
the client.
I would parse the sql file and create a csv file with just the columns of
your table and then use load data infile using the created csv file
Olaf
Olaf,
Using a Load Data on an empty file is at least 10x faster than
using SQL inserts. But I thought his blob field was binary (images) in
which case Load Data won't work. If his blob field is plain text, then of
course Load Data will work nicely. :)
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]