cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

Can neo4j help mysql flat table grouping?

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

0 REPLIES 0