4 ms·

I would have switched to a graph database like neo4j. Most if not all of your problems would be solved.