I'm observing it's become faster now: I'm wondering if it performed some sort of computation the very first time I tryed to access the db?
Il giorno martedì 10 marzo 2015 00:55:41 UTC+1, Michael Hunger ha scritto: > > 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.
