MySQL Forums
Forum List  »  Newbie

MYSQL manual using MANY frequently changing Varchar(255)
Posted by: david Manti
Date: December 27, 2010 01:32PM

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?

Options: ReplyQuote

Written By
MYSQL manual using MANY frequently changing Varchar(255)
December 27, 2010 01:32PM

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.