插入时MySQL InnoDB VARCHAR性能与TEXT的对比(MySQL InnoDB VARCHAR performance versus TEXT on inserts)

插入时MySQL InnoDB VARCHAR性能与TEXT的对比(MySQL InnoDB VARCHAR performance versus TEXT on inserts)

使用MySQL 5 InnoDB应该将varchar用于表中您希望插入很多内容的文本上？ 我打算存储最长为2000个字符的文本。

Using MySQL 5 InnoDB should varchar be used over text in a table where you expect many inserts? I intend to store text with a maximum length of 2000 characters.

最满意答案

VARCHAR和TEXT存储在MySQL的InnoDB存储引擎中。 没有性能差异。

请参阅Innodb中的Blob存储以获得大量详细解释。

这两种数据类型唯一的区别是VARCHAR可以有DEFAULT，而TEXT则不能。

VARCHAR and TEXT are stored identically in MySQL's InnoDB storage engine. There is no performance difference.

See Blob Storage in Innodb for lots of detailed explanation.

The only difference between these two data types is that VARCHAR can have a DEFAULT, whereas TEXT cannot.