How are unlimited fields stored?
From: stu <smcgouga_at_nospam.co.uk>
Date: Wed, 23 Oct 2002 09:33:51 +0100
Message-ID: <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?
Date: Wed, 23 Oct 2002 09:33:51 +0100
Message-ID: <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?
Cheers
Stu
Received on Wed Oct 23 2002 - 10:33:51 CEST