Question

I m 寻求帮助,使协会能够按要求负荷工作。

这是一个简化的例子。我有3个模型:Post,Comment,User/code>。参考资料:Post 有许多评论和<代码>Comment参考User(作者)。在我上台时,我期望看到邮局+所有评论(及其各自的作者姓名)。这就需要以下两个问题:

select * from Post -- to get post data (1 row)
select * from Comment inner join User -- to get comment + usernames (N rows)

在法典中,我有:

Post.find(params[:id], :include => { :comments => [:author] }

但是,它不像预期的那样工作:正如我在后面看到的那样,N+1的点击仍然重新发生(其中一些点击)。我如何能够优化这一努力?

UPD After some investigation, it looks like code was correct, but it doesn t work as expected in case I have named belongs_to in a Comment model. Once I changed from :author to :user, it worked as expected.

Answer 1

在我的项目中,我与您的<代码>Post、Comment/code>和User模式有着类似的关系。我只看到3个实际的q。



Post.find(1, :include => { :comments => [:author] })


从减标记录中可以看出这三个问题。

SELECT * FROM `posts` WHERE (`posts`.`id` = 1)
SELECT `comments`.* FROM `comments` WHERE (`comments`.`post_id` = 1)
SELECT * FROM `authors` WHERE (`authors`.`id` IN (4,8,15,16,23,42))

Answer 2

如果你满意2/3的询问,你可以尝试:

@post = Post.find params[:id]
@comments = Comments.find_by_post_id(params[:id], :include => [:auth或])

或

@comments = @post.comments(:include => [:auth或])

Edit: 您:

Post.find(params[:id], :include => { :comments => :auth或 }

友情链接