Hi I have written code like this
1) Without :include
My code is :-
def user_details
@user=User.find(params[:id])
@[email protected]
end
Log Output:-
Processing UsersController#user_details (for 127.0.0.1 at 2010-08-11
10:51:34) [GET]
Parameters: {"id"=>"2"}
User Columns (1.0ms) SHOW FIELDS FROM `users`
User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.`id` = 2)
Company Load (0.4ms) SELECT * FROM `companies` WHERE
(`companies`.user_id = 2) LIMIT 1
Rendering template within layouts/users
Rendering users/user_details
Completed in 65ms (View: 48, DB: 2) | 200 OK
[http://localhost/user_xml?id=2]
2) With Include:-
def user_details
@user=User.find(params[:id], :include=>:company)
@[email protected]
end
Log Output:-
Processing UsersController#user_details (for 127.0.0.1 at 2010-08-11
10:53:13) [GET]
Parameters: {"id"=>"2"}
User Columns (1.2ms) SHOW FIELDS FROM `users`
User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.`id` = 2)
Company Load (0.3ms) SELECT * FROM `companies` WHERE
(`companies`.user_id = 2) LIMIT 1
Rendering template within layouts/users
Rendering users/user_details
Completed in 13ms (View: 2, DB: 2) | 200 OK
[http://localhost/user_xml?id=2]
If you look at the both o/p there is a query on company table in both
the cases.
What is the difference?
Thanks,
Mike
--
Posted via http://www.ruby-forum.com/.
--
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.
