Can neo4j help mysql flat table grouping?


(Hexufeng) #1

Hi,

I have a question for you.

If I have a flat table in mysql, which has tens of million of rows,

userId, eventId, detection_time, score

1, 1, 2018-01-01 00:01:00, 0.1

1, 1, 2018-01-01 00:05:00, 0.1

1, 2, 2018-01-01 00:01:00, 0.1

1, 3, 2018-01-01 00:01:00, 0.1

....

and I need to know total count for user for every 5 minutes / every day..

The thing here is for small amount of data, query is fast, but when I have 20million rows, grouping is becoming very slow.

I was wondering if neo4j can help here.

Hope to hear from your advice.

Thanks