Thanks, I have one of my member also make an experiment with index. I will send you the effect of it.
----- Original Message ----- From: "Michael Hunger" <[email protected]> To: [email protected] Cc: "Ryan Velasco" <[email protected]> Sent: Wednesday, March 18, 2015 5:30:20 PM Subject: Re: [Neo4j] How does query profiler work? Right, you don't want to do that, there is currently no index support for range queries. Your query pulls all nodes and their properties into memory and does the comparison there. Usually you have some other criteria to limit the search first. For this concrete use-case it seems that you're looking at subscriptions outside of a certain time range, you can also tag them with an additional label I suggest that you either add something like a time-tree to your graph to structure your subscriptions. see: http://neo4j.com/docs/stable/cypher-cookbook-path-tree.html or http://graphaware.com/neo4j/2014/08/20/graphaware-neo4j-timetree.html Or you store a lower resolution date property e.g. down to the year, month or day level, index it create index on :Subscription(start); and do a lookup via (s.start IN range(2012,2000)) > Am 18.03.2015 um 10:22 schrieb Ryan John Velasco <[email protected]>: > > Thanks, I tried to put a Profile is some of our queries and there are queries > that have 3M hits. Sample query is > MATCH (n:Subscription) > WHERE (n.SubscriptionStartDate IS NULL or n.SubscriptionStartDate <= > 635622637370000000) and (n.SubscriptionEndDate IS NULL or > n.SubscriptionEndDate >= 635622637370000000) > RETURN count(n) > > Best Regards, > Ryan John Velasco > > ----- Original Message ----- > From: "Michael Hunger" <[email protected]> > To: [email protected] > Sent: Tuesday, March 17, 2015 9:20:12 PM > Subject: Re: [Neo4j] How does query profiler work? > > There is some more logging of queries in more recent versions. > > > in neo4j.properties > > > > dbms.querylog.enabled=true > # in ms > dbms.querylog.threshold=500 > dbms.querylog.path=data/log/queries.log > > > in neo4j 2.2 you can prepend EXPLAIN to a query which will show you the query > plan visually (in the browser) or textually (in Neo4j shell) it doesn't run > the query. > > > If you use PROFILE it will run the query and show also the db-hits. > > > As you haven't shared your queries or data model, there is not more I can > help you with. > > > Cheers; Michael > > > > > > > > Am 17.03.2015 um 05:14 schrieb Ryan Velasco < [email protected] >: > > > Thanks for the reply. > How do you do query profiling? I have observed that if sql server is eating > the memory the neo4j query goes slow. Maybe in production it will be > different. Because we plan to dedicate a machine with only neo4j installed on > it. Do you have a good specs for a computer? We plan to use a machine with > Core i7 and 8GB of memory. Is there a feature that I can view history of > queries made and the time it took to retrieve the data? > > > Thanks, > Ryan > > On Monday, March 16, 2015 at 7:33:08 PM UTC+8, Michael Hunger wrote: > > > Please always include the information about the actual queries you run and > the actual dataset information. > Otherwise no one can help you > > > and you should also include the profiling info of your two queries. > > > Also try to measure query performance from the Neo4j-shell to see the least > impact from drivers or additional requests in the neo4j-browser. > You can also use: http://localhost:7474/webadmin/#/console/ for that query > time testing. > > > Michael > > > > > > Am 16.03.2015 um 10:43 schrieb Ryan Velasco < [email protected] >: > > > Hello, > > > If I run a query 2 it goes faster but if I run it with other queries the 2nd > time, it is still slow. > > > Best Regards, > Ryan <Run with many queries.png> <Run the queries many times alone.png> > > > > -- > 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 a topic in the Google > Groups "Neo4j" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/neo4j/M8NVlEvjXKU/unsubscribe . > To unsubscribe from this group and all its topics, send an email to > [email protected] . > For more options, visit https://groups.google.com/d/optout . > <plan.png> -- 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.
