MySQL: Storage of multiple text fields for a record
- by Tom
An inexperienced question:
I need to store about 10 unknown-length text fields per record into a MySQL table. I expect no more than 50K rows in total for this table but speed is important. The database actions will be solely SELECTs for all practical purposes. I'm using InnoDB.
In other words:
id | text1 | text2 | text3 | .... | text10
As I…