> Am 16.04.2015 um 21:18 schrieb Daniele El-Jaick <[email protected]>: > > Ok, thank you. > I am just trying to undersatand why a same query, in a same graph, has very > different query times in each execution. Sometimes starts with 4000 ms, and > when I run again decreese to 200 ms.
It's a dynamic system: - queries are compiled and planend the first time they are run and cached, (that's what you measure in the first run) subsequent queries are taken from that cache and executed directly - the jvm warms up when the JIT kicks in after a while and optimizes the code - garbage collection happens now and then There will be no fixed time that you get for any query, my suggestion is to run it 5-10 times upfront and then measure the next 10 and take the average. Also your graphs are tiny and shouldn't make a difference if the queries are sensible. Michael > I am using neo in my doctor degree thesis. > I need to measure queries times in graphs with 1000, 5000, 1000 and 50000 > nodes. > I cant get a precise time. > Each run has a time, and they are very different. > In java the times are longer, and graphs with very different sizes have very > similar times for the same query. > I am looking for more precisely form to measure queries times. > Thnak you again. > > Em quarta-feira, 15 de abril de 2015 22:33:08 UTC-3, Michael Hunger escreveu: > Try 2.2.1 instead > > browser roundtrip times, as you return potentially a huge amount of > information also serialization, network transport, json parsing, and > rendering. > Michael > >> Am 16.04.2015 um 02:13 schrieb Daniele El-Jaick <daniej....@ <>gmail.com >> <http://gmail.com/>>: >> >> 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 <daniej....@ <>gmail.com >>> <http://gmail.com/>>: >>> >>> 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 neo4j+un...@ <>googlegroups.com <http://googlegroups.com/>. >>>> For more options, visit https://groups.google.com/d/optout >>>> <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 >>> <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 >> <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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <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.
