List:General Discussion« Previous MessageNext Message »
From:Bruce Douglas Date:January 1 1970 12:00am
Subject:RE: Social Networking querys
View as plain text  
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 <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



DVP
----
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.


> 
> Balazs
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?unsub=1
> 
> 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


Thread
Social Networking queryslistsql listsql2 Feb
  • Re: Social Networking querysPeter Brawley2 Feb
    • Re: Social Networking querysNick Arnett2 Feb
  • Re: Social Networking querysBalazs Rauznitz2 Feb
  • Re: Social Networking querysNick Arnett2 Feb
  • Re: Social Networking querysMichael Dykman2 Feb
Re: Social Networking querysBruce Douglas2 Feb
  • Re: Social Networking querysBalazs Rauznitz2 Feb
Re: Social Networking querysBruce Douglas2 Feb
Re: Social Networking querysBruce Douglas2 Feb
RE: Social Networking querysDathan Pattishall2 Feb
RE: Social Networking querysBruce Douglas2 Feb
  • Re: Social Networking querysBalazs Rauznitz2 Feb
    • Re: Social Networking querysMark Papadakis2 Feb
RE: Social Networking querysDathan Pattishall2 Feb
Re: Social Networking querysBruce Douglas2 Feb
  • Re: Social Networking querysBalazs Rauznitz2 Feb
Re: Social Networking queryslistsql listsql2 Feb