Re: text field

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? Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list