Hi. Under Starter I just found "settings". I´m using version 2.1.5. What affects the execution time of queries in Web Interface to vary like this? Thanks a lot
Em quarta-feira, 15 de abril de 2015 19:19:42 UTC-3, Michael Hunger escreveu: > > Hi, > > there should be a link to the neo4j-shell under "Options" of the Starter. > > Which version are you using? > > can you provide a query plan with EXPLAIN MATCH ... > > You can also try: > > PLANNER COST MATCH ... > > Michael > > Am 15.04.2015 um 23:25 schrieb Daniele El-Jaick <[email protected] > <javascript:>>: > > Hi. > I have installed the "Neo4j Community Installer", which is > .exe packaged Windows installer with bundled JRE. I can´t find Neo Shell > in it. > I am running several queries. > For example, > > > MATCH p= (e:ENTITY{Cod: 'E9'})-[:INFORMED|USED|DERIVED|GENERATED*]->(n) > WITH > DISTINCT p RETURN (extract(n IN nodes(p)| n.Cod)) as Path, (extract(r IN > relationships(p)|r)) as Rel > > All your paths should be distinct anyway, how many entries are returned? > > You expand your path ad infinitum, e.g if you have 100 rels fan out and 10 > steps you are at 100^10 paths. > > In a graph with 1.000 nodes this query times vary in web interface from > 3.600 ms to 140 ms. > > It depends on my internet connection, does not? > > no it does not. > > In java I got 870 ms in average. > Thanks > > > > Em quarta-feira, 15 de abril de 2015 17:31:01 UTC-3, Michael Hunger > escreveu: >> >> I usually use the neo4j-shell. >> >> It takes a a few runs to warmup the JVM, compile the queries and create a >> hot-working dataset. >> >> What times are you seeing? And what queries are you running? >> >> Michael >> >> Am 15.04.2015 um 21:47 schrieb Daniele El-Jaick <[email protected]>: >> >> How can I measure query times in web interface? Every time I run the same >> query I get a different time. >> In java I get longer times without variation for different sizes of >> graphs. >> Thanks >> >> -- >> 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. >> >> >> > -- > 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] <javascript:>. > 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
