MySQL Forums :: Newbie :: MYSQL manual using MANY frequently changing Varchar(255)


Advanced Search

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


Subject Written By Posted
MYSQL manual using MANY frequently changing Varchar(255) david Manti 12/27/2010 01:32PM
Re: MYSQL manual using MANY frequently changing Varchar(255) Rick James 12/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.