I need some help and have been reading online but couldn't find a solid answer to my issue. I don't know how to store my hierarchical data in my innoDB-table.
The potential hierarchy could be 200+ million nodes with 15-20 depths. Once the hierarchy database is created, there is no plan to write to it but only reading.
What can I use? Are there methods to parallel this as well?