Brian
I you create a CHAR (256) column then the column will always reserve 256
Unicode characters plus a length field, i.e. 256*2+4 = 516 bytes. If you
want variable length strings then use the TEXT type, although this will be
slightly slower.
Regards
Peter Hearty
Lutris Technologies UK Ltd.
-----Original Message-----
From: Brian Sanchez <bsanchez@ara.com>
To: instantdb@enhydra.org <instantdb@enhydra.org>
Date: 07 July 2000 00:56
Subject: InstantDB: Memory consumption and column widths
>
> I have a fairly large database (a couple of thousand records) and I'd
>like to know what effect increasing the column width will have on the
>memory consumption of my application.
>
> If a column is declared as CHAR(256), is InstantDB using that as the
>absolute size of the column or the maximum size? For example, if I
>insert "foo" into that column, is that record consuming the full 256
>chars, or just enough to hold the string, which would be less than 5
>chars?
>
> Thanks,
> Brian Sanchez
> bsanchez@ara.com
>---------------------------------------------------------------------------
--
>To unsubscribe from this mailing list, send email to majordomo@enhydra.org
>with the text "unsubscribe instantdb" in the body of the email.
>If you have other questions regarding this mailing list, send email to
>the list admin at owner-instantdb@enhydra.org.
>
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|