MYSQL manual using MANY frequently changing Varchar(255)
MYSQL documentation says this:
"For MyISAM tables that change frequently, you should try to avoid all variable-length columns (VARCHAR, BLOB, and TEXT). The table uses dynamic row format if it includes even a single variable-length column. See Chapter 13, Storage Engines. "
The table I am building will have:
1st column: auto incrementing INT, set as primary key
Then 20 columns of Varchar(255)
3 million rows
The varchar columns will have text entered, usually around 100 characters, but in rare cases up to 255 characters could be entered. Every read of the table also does an update (data is read, processed and then table updated with new info), hence there is a lot of "change" on the table. But is this the same change the article quote above refers to?
I have been told this is a non "textbook" setup, but it is built for speed alone, and is ok. so, the question is does the manual quote above mean I should use Char(255) instead of varchar for my needs?
Subject
Written By
Posted
MYSQL manual using MANY frequently changing Varchar(255)
December 27, 2010 01:32PM
December 28, 2010 04:11PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.