On Mar 11, 3:44 pm, Frederick Cheung <[email protected]>
wrote:
> On Mar 11, 12:15 pm, cdubd <[email protected]> wrote:> render :partial =>
> @submission.comment_threads
>
> > but it still makes a separate database call for each comment.
>
> What database calls (ie what is the association that is getting loaded
> 1 at a time ?)
>
Here is the output to the log. You can see at the bottom, that when
the comment partials are rendered, there is a SELECT call to the
database for each comment.
Processing SubmissionsController#show (for 127.0.0.1 at 2009-03-11
12:50:20) [GET]
Parameters: {"id"=>"4-university-offers-beatles-degree"}
Submission Columns (2.2ms) SHOW FIELDS FROM `submissions`
Submission Load (0.9ms) SELECT * FROM `submissions` WHERE
(`submissions`.`id` = 4)
User Columns (3.2ms) SHOW FIELDS FROM `users`
User Load (1.2ms) SELECT * FROM `users` WHERE (`users`.`id` = 1)
Image Load (0.5ms) SELECT `images`.* FROM `images` WHERE
(`images`.submission_id = 4)
Comment Load (1.5ms) SELECT `comments`.* FROM `comments` WHERE
(`comments`.`commentable_id` = 4 and `comments`.`commentable_type` =
'Submission') ORDER BY created_at ASC
CACHE (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 1)
Rendering template within layouts/application
Rendering submissions/show
Rendered submissions/_submission (3.4ms)
Comment Load (1.3ms) SELECT * FROM `comments` WHERE
(`comments`.commentable_id = 4 AND `comments`.commentable_type =
'Submission' AND (`comments`.`parent_id` IS NULL)) ORDER BY created_at
ASC
CACHE (0.0ms) SELECT * FROM `comments` WHERE
(`comments`.commentable_id = 4 AND `comments`.commentable_type =
'Submission' AND (`comments`.`parent_id` IS NULL)) ORDER BY created_at
ASC
CACHE (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 1)
User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.`id` = 3)
Comment Load (0.9ms) SELECT * FROM `comments` WHERE
(`comments`.`id` = 7)
Rendered comments/_comment (62.6ms)
CACHE (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 1)
Comment Load (0.8ms) SELECT * FROM `comments` WHERE
(`comments`.`id` = 8)
Rendered comments/_comment (33.0ms)
CACHE (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 1)
Comment Load (0.8ms) SELECT * FROM `comments` WHERE
(`comments`.`id` = 9)
Rendered comments/_comment (46.4ms)
CACHE (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 1)
Comment Load (0.9ms) SELECT * FROM `comments` WHERE
(`comments`.`id` = 10)
Rendered comments/_comment (33.2ms)
CACHE (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 1)
Comment Load (0.9ms) SELECT * FROM `comments` WHERE
(`comments`.`id` = 11)
Rendered comments/_comment (32.2ms)
CACHE (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 1)
Comment Load (0.8ms) SELECT * FROM `comments` WHERE
(`comments`.`id` = 12)
Rendered comments/_comment (33.9ms)
CACHE (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 1)
Comment Load (0.8ms) SELECT * FROM `comments` WHERE
(`comments`.`id` = 13)
Rendered comments/_comment (33.5ms)
CACHE (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 1)
Comment Load (0.8ms) SELECT * FROM `comments` WHERE
(`comments`.`id` = 14)
CACHE (0.0ms) SELECT * FROM `comments` WHERE (`comments`.`id` =
14)
Rendered comments/_comment (32.8ms)
CACHE (0.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 1)
Comment Load (0.8ms) SELECT * FROM `comments` WHERE
(`comments`.`id` = 17)
Rendered comments/_comment (32.8ms)
Completed in 592ms (View: 371, DB: 19) | 200 OK [http://localhost/
submissions/4-university-offers-beatles-degree]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
