Newsgroups: comp.databases.theory Subject: Re: How are unlimited fields stored? From: Pablo Sanchez References: Message-ID: User-Agent: Xnews/5.04.25 NNTP-Posting-Host: newsfeeds2 Date: 23 Oct 2002 16:33:28 -0500 Lines: 14 X-Authenticated-User: $$yl_vltqb X-Comments: This message was posted through Newsfeeds.com X-Comments2: IMPORTANT: Newsfeeds.com does not condone, nor support, spam or any illegal or copyrighted postings. X-Comments3: IMPORTANT: Under NO circumstances will postings containing illegal or copyrighted material through this service be tolerated!! X-Report: Please report illegal or inappropriate use to You may also use our online abuse reporting from: http://www.newsfeeds.com/abuseform.htm X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body (DO NOT SEND ATTACHMENTS) Organization: Newsfeeds.com http://www.newsfeeds.com 100,000+ UNCENSORED Newsgroups. Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!feedwest.aleron.net!aleron.net!l-out.nntp.be!corp-news.newsgroups.com!not-for-mail Xref: newsfeed1.easynews.com comp.databases.theory:23098 X-Received-Date: Wed, 23 Oct 2002 14:39:08 MST (news.easynews.com) "stu" wrote in news:ap5mue$s7m$1$8300dec7@news.demon.co.uk: > How are large unlimited fields stored? I think im right when i say > if you have a TEXT(30) and only use 3 chars the dbms will physically > layout 30 char space before the start of the next record. This is > fine but how does the dbms handle memo fields that can be huge? I don't know what a memo field is but assuming that it's similar to CLOB/BLOB's, the RDBMS typically chain together their atomic storage unit, to accommodate monster fields. -- Pablo Sanchez, High-Performance Database Engineering http://www.hpdbe.com