Neo4j

vjramirez · 01-23-2019

Hello, I'm testing different databases to storage time series. I have some results using cassandra and InfluxDB. Now, I am trying with Neo4j Community using the schema suggested in https://www.graphgrid.com/modeling-time-series-data-with-neo4j/ I hav...

vjramirez · 01-28-2019

Hi Andrew, These are the expanded query plans, I've created an index on :Sensor(id): PROFILE MATCH (s:Sensor{id:'XXXXXX'})-[:MAKE_OBSERVATION]->(o:Observation) WHERE o.date >= datetime({year:2018, month:12, day:11, hour:0, minute:0, second:0}) AND o...

vjramirez · 01-24-2019

Hello Andrew, thanks for your replay. Currently, the property o.date is a datetime type (i.e. "2018-12-11T00:10:47Z") and there is an index on :Observation(date). So, the query: "PROFILE MATCH (s:Sensor{id:'XXXXXX'})-[:MAKE_OBSERVATION]->(o:Observati...

vjramirez · 01-24-2019

Thanks David for your reply. Using your suggestion, now the query is: "PROFILE MATCH (s:Sensor{id:'XXXXXX'})-[:MAKE_OBSERVATION]->(o:Observation) WHERE o.date.year=2018 AND o.date.month=12 AND o.date.day=11 RETURN s.id, o.date, o.value;" (I'm using P...

Neo4j

User Statistics

User Activity

Slow performance on time series queries

Re: Slow performance on time series queries

Re: Slow performance on time series queries

Re: Slow performance on time series queries