monarch-initiative / monarch-cypher-queries

4 stars 3 forks source link

Remove distinct and use UNION ALL in golr queries #20

Closed kshefchek closed 7 years ago

kshefchek commented 7 years ago

Our golr queries make use of DISTINCT and UNION for joining and uniquifying paths and sub, pred, obj triples. This is memory intensive, and is possibly no longer required given the @jnguyenx's tinker graph refactor on the golr loader side. In testing this has improved memory usage, where memory usage is roughly equal to the graph size on disk, where as before we were using 2-3x size on disk.

Will first test this on the golr loader side and then with a full graph to see how this affects indexing speed.