[V4MD] Database size

[Scott Runkel]

version 1.9.8
Fields as below, and literally the amount of stuff in them is almost nothing,
like a single word or number in each field, for 271 records.

<FieldCount>8</FieldCount>
- <FieldDesc Name="year">
  <Type>UShort</Type>
  <Indexed>1</Indexed>
  <Unique>0</Unique>
  <Nullable>0</Nullable>
  <IndexByWords>0</IndexByWords>
  <Compressed>0</Compressed>
  </FieldDesc>
- <FieldDesc Name="itemnum">
  <Type>UShort</Type>
  <Indexed>0</Indexed>
  <Unique>0</Unique>
  <Nullable>0</Nullable>
  <IndexByWords>0</IndexByWords>
  <Compressed>0</Compressed>
  </FieldDesc>
- <FieldDesc Name="specialty">
  <Type>VarChar</Type>
  <Indexed>1</Indexed>
  <Unique>0</Unique>
  <Nullable>0</Nullable>
  <IndexByWords>0</IndexByWords>
  <Compressed>0</Compressed>
  <MaxLength>255</MaxLength>
  <Language>ASCII</Language>
  </FieldDesc>
- <FieldDesc Name="question">
  <Type>Text</Type>
  <Indexed>1</Indexed>
  <Unique>0</Unique>
  <Nullable>0</Nullable>
  <IndexByWords>1</IndexByWords>
  <Compressed>0</Compressed>
  <Language>ASCII</Language>
  <SegmentSize>20480</SegmentSize>
  </FieldDesc>
- <FieldDesc Name="critique">
  <Type>Text</Type>
  <Indexed>1</Indexed>
  <Unique>0</Unique>
  <Nullable>0</Nullable>
  <IndexByWords>1</IndexByWords>
  <Compressed>0</Compressed>
  <Language>ASCII</Language>
  <SegmentSize>204800</SegmentSize>
  </FieldDesc>
- <FieldDesc Name="correct">
  <Type>VarChar</Type>
  <Indexed>0</Indexed>
  <Unique>0</Unique>
  <Nullable>0</Nullable>
  <IndexByWords>0</IndexByWords>
  <Compressed>0</Compressed>
  <MaxLength>2</MaxLength>
  <Language>ASCII</Language>
  </FieldDesc>
- <FieldDesc Name="memberq">
  <Type>VarChar</Type>
  <Indexed>0</Indexed>
  <Unique>0</Unique>
  <Nullable>0</Nullable>
  <IndexByWords>0</IndexByWords>
  <Compressed>0</Compressed>
  <MaxLength>255</MaxLength>
  <Language>ASCII</Language>
  </FieldDesc>
- <FieldDesc Name="memberc">
  <Type>VarChar</Type>
  <Indexed>0</Indexed>
  <Unique>0</Unique>
  <Nullable>0</Nullable>
  <IndexByWords>0</IndexByWords>
  <Compressed>0</Compressed>
  <MaxLength>255</MaxLength>
  <Language>ASCII</Language>

-SR

Scott Runkel
Director of Technology
503-722-2123
----- Original Message ----- 
From: "Claudius Sailer" <Claudius at sailer-online.de>
To: "Valentina Developers" <valentina at lists.macserve.net>
Sent: Thursday, November 13, 2003 9:23 PM
Subject: Re: [V4MD] Database size


> Hi,
>
> Am 14. Nov 2003 um 03:06 Uhr schrieb Scott Runkel:
>
> > Just created my first database, which has 8 fields. I put in 271
> > records, each
> > of which has only a tiny amount of data. The XML dump of the whole
> > thing is
> > 77KB. But the ".blb" file for the same database is 60 MB.
>
> What type of fields do you use?
> What is your valentina-version?
>
> Bye
>
>
> Claudius
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>