dathan... 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!!! regards, bruce -----Original Message----- From: Dathan Pattishall <[EMAIL PROTECTED]> Sent: Feb 2, 2005 10:04 AM To: Balazs Rauznitz <[EMAIL PROTECTED]>, listsql listsql <[EMAIL PROTECTED]> Cc: mysql <mysql@lists.mysql.com> Subject: RE: Social Networking querys DVP ---- Dathan Vance Pattishall http://www.friendster.com > -----Original Message----- > From: Balazs Rauznitz [mailto:[EMAIL PROTECTED] > 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. > > Balazs > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]