Having multiple text column vs single text column

MySQL & MariaDB Other MySQL® Questions
1

Having multiple text column vs single text column or a medium text column, which should handle things better?

2

@onlyrohits,

I assume this is InnoDB? One reason to go with single TEXT field is performance. A single TEXT field will only maintain one singly-linked-list of overflow pages, while multiple TEXT columns means if several of them requires overflow pages then the work is increased. Note that each TEXT column will have its own set of overflow pages, if these overflow pages do not have a good fill factor, you will be wasting disk space too.

[url]http://dev.mysql.com/doc/refman/5.6/en/innodb-row-format-overview.html[/url]

3

Oh, and this too [url]http://www.mysqlperformanceblog.com/2010/02/09/blob-storage-in-innodb/[/url] :slight_smile: