[Neo] Property name storage

Johan Svensson johan at neotechnology.com
Mon Jan 4 11:45:30 CET 2010


Hi,

Each unique property name will be assigned an integer value. When
adding 100k properties with the same key the overhead for the key part
of that property will be 400k bytes regardless of length of the
property key.

We will add some information about this on the wiki.

Regards,
Johan

On Sat, Jan 2, 2010 at 4:34 PM, Craig Taverner <craig at amanzi.com> wrote:
> Hi,
>
> I was wondering, how much space does a property name occupy in the database?
> I mean if I use a name like 'x' or one like
> 'supercalifragilisticexpialidocious', and create that same property on 100k
> nodes, would the longer one cause a much larger database, or are the
> property names looked up in a kind of global symbol table?
>
> This is important to me because I load data where the property names are
> based on whatever text the user used in the input file, so that the user can
> see the same names they are familiar with in the database views and in any
> analyses. This means I have no direct control over choice of property names
> and cannot optimize the database size should I need to.
>
> If the name text is replicated in all nodes, then perhaps I need to write an
> application level symbol table, and use a hash or index as the property
> name. This is obviously not ideal. Any comments? I've done a quick search of
> the wiki and found no answers to this.
>
> Regards, Craig


More information about the User mailing list