Oh and the counting doesn't use an index (right now, it might use the kernel statistics at some point).
On Tuesday, March 10, 2015 at 12:41:12 AM UTC+1, Lorenzo Speranzoni (@inserpio) wrote: > > Hi All, > > I'm testing performances on a 1 Billion nodes database. > > To create nodes I used Michael Hunger's code here: > https://gist.github.com/jexp/0ff850ab2ce41c9ca5e6 > > The import when really well: it took 5m 22s 235ms > > But when I try to connect to the just created database via shell, I took > really long time. > That the command I run; > > JAVA_OPTS="-Xmx16G -Xms16G -server -d64" ./neo4j-shell -path /path/to/db/ > I also takes a long time to count the overall nodes, even with an index: > > neo4j-sh (?)$ create index on :Person(id); > > +-------------------+ > > | No data returned. | > > +-------------------+ > > Indexes added: 1 > > 524 ms > > > neo4j-sh (?)$ match (n) return count(n); > > +------------+ > > | count(n) | > > +------------+ > > | 1000000000 | > > +------------+ > > 1 row > > 430730 ms > > > Thanks in advance for the help! > > Lorenzo > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
