Re: How are unlimited fields stored?
From: Pablo Sanchez <pablo_at_dev.null>
Date: 23 Oct 2002 16:33:28 -0500
Message-ID: <Xns92B09F343C713pingottpingottbah_at_209.189.89.243>
Date: 23 Oct 2002 16:33:28 -0500
Message-ID: <Xns92B09F343C713pingottpingottbah_at_209.189.89.243>
"stu" <smcgouga_at_nospam.co.uk> wrote in news:ap5mue$s7m$1$8300dec7_at_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.comReceived on Wed Oct 23 2002 - 23:33:28 CEST