extremely slow INSERT (blob)

[vermaha]

SITUATION:
've got about 3 Megs of JPG data saved in blob fields. I've backed up the table from an account provider (I don't have the choice of copying the table files from the database server).

PROBLEM:
Now when I try to recreate this database locally on a Windows-machine, the insert statements with the blob data seem to take forever (several minutes for one blob of 20k for example), some statements never even seem to be completed.

QUESTION:
The weird thing is that if I just insert ONE new record at a time, Mysql does its job. As soon as I run 3 consequent inserts, the second insert will take about twice as long as the first one (with exactly the same amount of blob data).
** How is this possible?

If I do it on a Linux machine, it works fine and is considerably faster.

** Is there something wrong with my Windows MySQL configuration or is it just machine spec difference?
If not, is there a way to speed it up?

[Pig]

I cannot answer your question directly. However, this is a perfect example of why it is standard practice to keeps links in your database and large files in a regular directory. It might be worth it to side step the issue altogether and change your setup. HTH.

[AstroTeg]

I would totally agree with Pig. It would be a lot easier to FTP down the files and then FTP them up to their new location. Then you could bypass the issues associated with blob data, which looks like you found one with MySQL + Windows.