Re: Mysql long text field - slow performance

[Rick James]

Strange. Would you care to give some more details. A simple test case that, I think, meets your description does not show the problem:

mysql> CREATE TABLE f378680m ( x LONGTEXT NOT NULL ) ENGINE=MyISAM;
Query OK, 0 rows affected (1.07 sec)

mysql> CREATE TABLE f378680i ( x LONGTEXT NOT NULL ) ENGINE=InnoDB;
Query OK, 0 rows affected (0.81 sec)

mysql> INSERT INTO f378680m VALUES ('abcd');
Query OK, 1 row affected (0.04 sec)

mysql> INSERT INTO f378680i VALUES ('abcd');
Query OK, 1 row affected (0.10 sec)

Also, what language are you using to do the INSERTs? The API may be involved (unlikely).