I am doing a system similar to a social network. The number max of users must be eventually 50.000 or 70.000 at best.
At the moment i am using mysqli+prepared statments. The ERD have now 30 tables, eventually may reach to 40 tables.
So, my question is: i never used a graph database…i have the ERD done by mysql workbench and some code already developed. For the number expected of the users in this project, is recommended change from MySQL to a graph database? my sql code and database model can be availed? there is any advantage with this change?
at the moment i have a big problem. Some people recommend me move to Allegrograph (i never used), other people to use PostgreSQL because the recursive queries (i never used) and other tells to me to read Joe Celko’s Trees and Hierarchies in SQL for Smarties (Morgan Kaufmann, 2004)