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]