rails select with includes

ruby-on-rails activerecord rails-postgresql
Remon Amin picture Remon Amin · Aug 2, 2013 · Viewed 13.2k times · Source

I have these code in my rails 3.2 application 

User.includes(:profile).limit(10)

which select all fields from profiles table I need a way to select on specific fields from profiles table to decrease db queries I am using postgresql

Answer

Hassan Javeed picture Hassan Javeed · Aug 2, 2013

You're better of using something like

User.joins(:profile).select("users.*, profiles.field1, profiles.field2").limit(10)

Related questions

Batch insertion in rails 3

I want to do a batch insert of few thousand records into the database (POSTGRES in my case) from within my Rails App. What would be the "Rails way" of doing it? Something which is fast and also correct way …

Read More
Creating a PostgreSQL sequence to a field (which is not the ID of the record)

I am working on a Ruby on Rails app. We are using a PostgreSQL database. There is a table named scores with the following columns: Column | Type --------------+----------------------- id | integer value | double precision ran_at | timestamp active | boolean build_…

Read More
How to drop columns using Rails migration

What's the syntax for dropping a database table column through a Rails migration?

Read More