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 . -- 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.
