rails, optimize db query

Question

I have such models structure:

class Entity < ActiveRecord::Base
  habtm :properties_1
  # ... 
  habtm :properties_N
end

I need to write request by any set of properties, it causes N joins:

Entity.joins(:properties_1, :properties_N).where("properties_1.id = ? AND properties.N = ?", p1_id, pN_id)

N may be > 20

What can I use to increase query performance?

I think about caching all this settings to big table with serialized attributes, but it looks like this problem is common and, probably, any existed solution is present.

Any ideas?

Thanks for advance!

sumskyi · Accepted Answer · 2012-09-05 10:10:35Z

1

this is looks like Entity-Attribute-Value (EAV) pattern.

http://www.slideshare.net/stepanyuk/implementation-of-eav-pattern-for-activerecord-models-13263311

https://github.com/kostyantyn/hydra_attribute

EAV is not good solution in relational databases, it is better to use document-oriented DB like MongoDB

answered Sep 5, 2012 at 10:10

sumskyi

1,84513 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

rails, optimize db query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related