Defining Fields

[Warren Kuhl]

Ruslan,

Thanks for you feedback.  I zipped the database and you are right...it goes
from 30meg to 5meg which is great.  Thanks for the clarification on the
field sizes.  I wasn't sure if the storage was fixed or variable depending
on the length of the field in the database.

Have a wonderful weekend!

Warren


 at 11:34 AM, Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com> wrote:

> On 2/3/11 9:44 PM, "Warren Kuhl" <warrenkuhl at gmail.com> wrote:
>
> Hi Warren,
>
> > I have a table which I created with 2 fields as varchar(2040).  The table
> > contains around 40,000 records and the table takes up around 30 meg.
> >
> > Field 1 max length <= 100 characters (key field)
> > Field 2 max length <= 500 characters
> >
> > I am trying to get the table down in size from 30 meg.  Would varchar be
> the
> > best way to store a field(s) of this size (or string...or ???)?
> >
> > ie. Field 1 = varchar(100); Field 2= varchar(500)
>
> 1)
>
> You will nothing actually making VarChar(100).
> This only will setup top-limit and will truncate strings.
>
> Bigger MaxLength  do not eat more space.
>
>
> 2)
>
> Why you think 30M is too much?
> What size of e.g. Your text file with same strings?
>
> Keep in mind that db file contains strings in UTF16.
> So this is compared to 15MB UTF8  may be.
>
>
> 3) also what reason to fight with size?
> You need transfer that file?
> Try to make ZIP, I think you will be surprised.
>
>
>
> --
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20110206/bc12ff2e/attachment.htm>