Question

当拉迪加特1电文时,这是否意味着在其追随者身上插入1个数据记录(共计12 221 751美元)? 因此,插入了12,221,751个记录?

Any clues in designing such a social feed system?

页: 1 Edit公司页: 1

实际问题:

从Tweets([后续]])中进行“特别选举”是不可能的,这限制了IN条款中最多30项内容的“月球评估”引擎。

在评估发动机时,实际上意味着同时进行30次问答,但我猜想这样做并不明智。

Even if I am allowed to overtake the 30 limits, what if I am subscribing to 10000 people? I am not sure if there are any performance issues to do it in MYSQL or any other kind of database infrastructure using the "IN clause" (the bigtable of app engine is different from MYSQL)

So it is better to use the IN clause to query? or setting up a UserFeed table for storing the feed relationship? or 3rd method?

数据库/SQLguru

Answer 1

你们可以想象一下吗?

<>0>

每个人都有追随者名单

ID        |  FOLLOWER__ID
ladygaga  |  genesis
ladygaga  |  user

/

$result = mysql_query("SELECT ID FROM followers WHERE FOLLOWER__ID =  genesis ;");
while($row = mysql_fetch_assoc($result)){
    $select[] = $row[ ID ];
}

$tweets = mysql_query("SELECT * FROM tweets WHERE owner IN (".implode(",", $select).")");

友情链接