Save 36% for Black Friday! Learn more

New Discussion

Notifications

You’re not receiving notifications from this thread.

When to setup associations in Rails db?

0
Databases
I've always wondered if there is a better way to help database query performance in rails by breaking up tables with lots of columns? Any recommendations would be appreciated.

Does it make more sense to break out columns into another table or keep them in one?

Example: 

Client.name
Client.address
Client.city
Client.state
Client.zip
Client.twitter
Client.facebook
Client.instagram
Client.contact_name
Client.contact_phone
Client.contact_email
etc...

VS

Client.name

has_one :address
Client.address.address
Client.address.city
Client.address.state
Client.address.zip

has_one :social
Client.social.twitter
Client.social.facebook
Client.social.instagram

has_one :contact
Client.contact.name
Client.contact.phone
Client.contact.email


Join the discussion
Create an account Log in