[Neo] Property name storage
craig at amanzi.com
Sat Jan 2 16:34:43 CET 2010
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.
More information about the User