DVP ---- Dathan Vance Pattishall http://www.friendster.com
> -----Original Message----- > From: Bruce Douglas [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 02, 2005 10:20 AM > To: Dathan Pattishall > Cc: mysql@lists.mysql.com > Subject: RE: Social Networking querys > > 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?? We are going to present at the mySQL conference, and let people know how we created the storage engine not how we interact with our API via our storage engine. I could talk to the business guys to see if we can open up the API to allow other companies to use our sauce to run a social network application-but it will require a partnership etc. > > 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]