On 7/6/05, Robby Russell <[EMAIL PROTECTED]> wrote: > I wanted to follow up on this a bit more. I realized that we could > easily add another field to the articles table called 'comment_count' so > that we could utilize the counter cache. For some reason, when Curt logs > into his admin area, it times out because the number of comments is in > the several thousand. Do you think that this would help things?
There's a couple of things we have to tune performance-wise in the not-too-distant future. For one, typo makes no use of eager loading in the admin area yet (as far as I remember). Regarding the counter cache, there's a bug in that logic presently which is getting triggered if you populate the association upside down. The counter is only updated via @article.comments << Comment.new and not via @comment.article = Article.find() -- unless we can ensure that no single spot in our code populates associations the wrong way we can't potentially trust the counter cache. Other than that, Curt's logs might indicate a few other problematic queries I'd love to know about. Thanks. -- Patrick Lenz (scoop) http://poocs.net/ # Personal Weblog http://limited-overload.de/ # Web application development http://freshmeat.net/ # Free software archive http://topmedia.de/ # IT Storage Solutions
