given that you work at friendster, aren't you kind of restricted from commenting on how
one would go about creating/implementing this kind of system??
if you aren't and you have information to share, then we'd appreciate hearing it!!!
From: Dathan Pattishall <dathan@stripped>
Sent: Feb 2, 2005 10:04 AM
To: Balazs Rauznitz <balazs@stripped>, listsql listsql <listsql@stripped>
Cc: mysql <mysql@stripped>
Subject: RE: Social Networking querys
Dathan Vance Pattishall http://www.friendster.com
> -----Original Message-----
> From: Balazs Rauznitz [mailto:balazs@stripped]
> Sent: Wednesday, February 02, 2005 9:06 AM
> To: listsql listsql
> I work at a social networking company. We store the social
> network as an edge graph too, but do not use SQL to run
> queries on it. It'd be just way too slow in huge networks.
> There's a custom application creted in-house written in C to
> do that. Hope this was at least a little useful.
> Also there's somebody from Friendster here, he might be able
> to help you also.
We have our own storage engine that talks an API to our own C++ server
that stores the graph. Doing it with a pure myISAM engine is possible
but it's way to slow. Doing a self table join or subselect is really the
only way doing it, less you want to have some application logic that
issues 1000s of selects.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1