Re: text field

Posted in 2003

rkusenet — Wed, 24 Sep 2003 16:43:56 -0400 — source: Usenet: comp.databases.informix

"Mark D. Stock" <mdstock@mydassolutions.com> wrote in message news:bksvi3$48s$1@terabinaries.xmission.com... > > rkusenet wrote: > > > IDS 9.21. > > > > We are in the process of making a change in a heavy insert table. > > This table gets lot of inserts. A row , after getting inserted, > > is read and updated for next few minutes by another process. After > > that the row has no utility left and is deleted at the end of the > > day. > > > > One of the columns in the table is a VARCHAR column. This column > > now will store additional information which can run upto 20K in > > length. This means both VARCHAR and LVARCHAR can not store that > > size of information. My main concern is the performance penalty > > during insert if the column is changed to a text field. > > Why not use a CHAR? A char field of 20000 length???