felito — 2011-06-07T14:15:08-04:00 — #1
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?
what do you think ?
r937 — 2011-06-07T17:10:26-04:00 — #2
felito — 2011-06-07T17:21:19-04:00 — #3
well i never use a graph database.
So, if i will have some advantage i will choose one of them.
r937 — 2011-06-07T17:24:01-04:00 — #4
where did you hear about a graph database?
felito — 2011-06-07T17:28:17-04:00 — #5
i read that facebook, twitter, google, amazon, they use graph databases.
my question is in my case, there is some advantage over mysqli and prepared statements ?
r937 — 2011-06-07T18:06:16-04:00 — #6
sorry, i have no experience with this
does this help? -> Need a graph database like Twitter is built on? (YouTube)
i would say for you to try using a graph database would be quite ambitious
the first thing you're going to want to do is define your requirements for the relationships
felito — 2011-06-07T18:16:41-04:00 — #7
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)
i am completely lost.
r937 — 2011-06-07T18:28:17-04:00 — #8
like i said, i don't know any graph databases
but i do know about celko's nested set model, and it's intended for a hierarchy
you didn't mention what you're doing, but if it's not actually a graph but just a hierarchy, then that'd be the way to go -- you get to use mysql, too
felito — 2011-06-07T18:37:28-04:00 — #9
i have the database diagram in Attach.
Actually normal users can fallow other users and can fallow company's, and can answer to job offers. A company can fallow a normal user too.
In future, users can may belong to a department x or y belongs to a group.
this part is the problem.