Re: text field
rkusenet wrote: > "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??? You can go up to CHAR(32767) if you want. It will just be fixed length, that's all, but possibly easier to use than TEXT. As Colin says, you can use LVARCHAR of similar size in IDS version 9.40. However, in reality it is up to LVARCHAR(32739). 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
"Mark D. Stock" <mdstock@mydassolutions.com> wrote > > > > A char field of 20000 length??? > > You can go up to CHAR(32767) if you want. It will just be fixed length, > that's all, but possibly easier to use than TEXT. I know that CHAR can go up to 32K. I want to know whether it makes sense to have such a huge char field. It will fill out the buffers, logical logs rapidly. May be I will have to compare the speed of char(32K) with a text field in rapid inserts. Ravi.