Hi,

I'm developing an application that needs extensive blob support. I made some tests and I got the follwing performance values: inserting 50 records (one blob of 4Mb each) takes:

- 14 seconds in firebird - 20 seconds in SQL Server Express - 96 seconds in MySQL

I guess I'm doing something wrong. I just followed the sample at the connector's manual, writing something like:

string query = string.Empty;

query =

"INSERT INTO TESTDATA (iobjid, bdata) " +

"VALUES (?objid, ?val)";

// Save binary blob using named parameter

cmd.CommandText = query;

MySqlCommand mcmd = (MySqlCommand) cmd;

mcmd.Parameters.Add("?objid", objId);

mcmd.Parameters.Add("?val", data);

cmd.ExecuteNonQuery();

cmd.Parameters.Clear();

Should I change something?