LVARCHAR vs TEXT

Posted in 2008

Topics: Performance & Tuning, Data Types & Schema Design

FRANK — Fri, 29 Aug 2008 15:13:25 — source: IIUG Forums & Mailing Lists

Folks, Is there a comparison between TEXT and LVARCHAR, e.g., usage, performance, disk allocation, benefits, SQL/XML,....? Any suggestions/conclusions? Thanks a lot, Frank

↪ replying to FRANK

John Miller iii — Fri, 29 Aug 2008 15:57:58 — source: IIUG Forums & Mailing Lists

Here is a few things off the top of my head. LVARCHAR Partition Blob Max Size 32K - rowsize 2GB In row overhead 2 bytes 56 bytes cast to char Yes No by default Fills partial pages Yes Yes Hope this helps, John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) = "FRANK" = <yunyaoqu@gmail.c = om> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect LVARCHAR vs TEXT [13256] = 08/29/2008 08:13 = AM = = = Please respond to = ids@iiug.org = = = Folks, Is there a comparison between TEXT and LVARCHAR, e.g., usage, performan= ce, disk allocation, benefits, SQL/XML,....? Any suggestions/conclusions? Thanks a lot, Frank ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =