title: Store Hierarchical data in a best way: NoSQL or SQL
body: <p>I am working hierarchical data, as in the tree structure. i want to know what is the best way to store them in database.</p>
  
  <p>I started with adjacency list, in MySQL. But the performance seems to dip as the data is increasing. I have around 20,000 rows stored in a MySQL table with parent child relationship and will increase in future. Fetching data is taking very long time as I have to write many self joins depending upon the depth of the tree. </p>
  
  <p>So I was searching for best way to store this kind of data. In once place I found Nested Sets is better way than adjacency lists. Then I was advised to look upon NoSQL, if that would solve my problem. So I am confused now whether to remain in SQL or go into No SQL or if there is any other best way to handle this kind of data.</p>
  
  <p>So can anyone suggest me what is the best way??</p>