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 <cr...@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 _______________________________________________ Neo mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
