A query to do that is: match (n) with n.name as name count(n)
But that's not very efficient. On Mon, Mar 13, 2017 at 7:49 PM, unrealadmin23 via Neo4j < neo4j@googlegroups.com> wrote: > Ok - so how do I do that ? Each node has a node.name which I would like > to cache. > > Wayne > > On Monday, 13 March 2017 17:19:59 UTC, Michael Hunger wrote: >> >> You can but its not as general as nodes and rels and harder to implement >> efficiently >> >> Von meinem iPhone gesendet >> >> Am 13.03.2017 um 13:25 schrieb unrealadmin23 via Neo4j < >> ne...@googlegroups.com>: >> >> Ok, so I have set: >> dbms.memory.pagecache.size=81g >> >> Restarted Neo4j and run: >> >> call apoc.warmup.run() ; >> >> My process allocation is now 200GB (Good). >> I will try some tests to see how the performance compares. >> >> Question - why can't you cache the properties also ? I use ".name" a >> lot. >> >> >> On Monday, 13 March 2017 08:14:57 UTC, Michael Hunger wrote: >>> >>> Can you please comment in the pagecache setting and put it (it close to >>> the sum of neostore.*.db) files but keep the total memory and heap into >>> account >>> >>> >>> >>> Von meinem iPhone gesendet >>> >>> Am 13.03.2017 um 08:54 schrieb unrealadmin23 via Neo4j < >>> ne...@googlegroups.com>: >>> >>> I have the following settings in neo4j.conf: >>> >>> This is about 1/8th of the machines memory: >>> >>> dbms.memory.heap.initial_size=120000m >>> dbms.memory.heap.max_size=120000m >>> >>> >>> The page cache is commented out: >>> #dbms.memory.pagecache.size=10g >>> >>> Wayne >>> >>> >>> On Monday, 13 March 2017 02:35:00 UTC, Michael Hunger wrote: >>>> >>>> What does your configuration look like in neo4j.conf for heap and >>>> page-cache? >>>> >>>> neo4j> call apoc.warmup.run() ; >>>> pageSize nodesPerPage nodesTotal nodePages nodesTime relsPerPage >>>> relsTotal >>>> 8192 546 123396013 226001 2 240 2035429925 <(203)%20542-9925> >>>> relPages relsTime totalTime >>>> 8480959 73 76 >>>> >>>> so it loaded 226001 pages of nodes totalling 123m = 1.7 GB >>>> and 8480959 pages of relationships totalling 2bn = 65 GB >>>> >>>> in 76 seconds >>>> >>>> So depending on your configuration you either have now 67GB of >>>> page-cache filled or it spilled over. >>>> >>>> All operations that now require only node or relationship-record access >>>> should access them in-memory. >>>> >>>> Operations that require properties will still need to load them into >>>> the page-cache and depending on the size setup displace existing entries. >>>> >>>> >>>> >>>> On Sun, Mar 12, 2017 at 4:45 PM, unrealadmin23 via Neo4j < >>>> ne...@googlegroups.com> wrote: >>>> >>>>> I installed apoc - I didn't know this existed - looks very >>>>> comprehensive; thanks: >>>>> >>>>> neo4j> call apoc.warmup.run() ; >>>>> pageSize, nodesPerPage, nodesTotal, nodePages, nodesTime, relsPerPage, >>>>> relsTotal, relPages, relsTime, totalTime >>>>> 8192, 546, 123396013, 226001, 2, 240, 2035429925, 8480959, 73, 76 >>>>> >>>>> Not much in the way of a noticeable speedup though. >>>>> >>>>> I don't know anything about Java, and cannot find the jvm command. >>>>> Can you be more specific about what I need to run or configure from the >>>>> Linux command line ? >>>>> >>>>> Wayne. >>>>> >>>>> >>>>> On Saturday, 11 March 2017 10:14:49 UTC, Michael Hunger wrote: >>>>>> >>>>>> There is not a kernel buffer, but own own page cache that you have to >>>>>> configure >>>>>> >>>>>> call apoc.warmup.run() >>>>>> >>>>>> Which warms up node and rel blocks >>>>>> >>>>>> Other speedup comes from jvm JIT warmup >>>>>> >>>>>> >>>>>> Von meinem iPhone gesendet >>>>>> >>>>>> Am 11.03.2017 um 08:28 schrieb unrealadmin23 via Neo4j < >>>>>> ne...@googlegroups.com>: >>>>>> >>>>>> Hi, >>>>>> >>>>>> Assuming that I have enough memory to loaded the entire DB into it, >>>>>> are there any options (optimisations) to allow for this or is it just a >>>>>> case of the disk blocks being able to reside in the kernels buffer cache >>>>>> ? >>>>>> >>>>>> Currently, the same query gets faster the more it is run - to a >>>>>> point. I can live with an elongated startup time. >>>>>> >>>>>> Thanks, Wayne >>>>>> >>>>>> -- >>>>>> 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 neo4j+un...@googlegroups.com. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>>> -- >>>>> 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 neo4j+un...@googlegroups.com. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> -- >>> 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 neo4j+un...@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >>> -- >> 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 neo4j+un...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> >> -- > 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 neo4j+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- 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 neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.