I have 4-5 different types of models which can be tagged. So, in the
table should I declare a multicolumn index on [taggable_type,
a single column index on [taggable_id]. What are the pros and cons of
and which one is preferred?
If multicolumn, then in what order, i.e., [taggable_type, taggable_id]
should it be [taggable_id, taggable_type]?
I have another table for tracking views for different objects, and this
there are 3 columns [viewable_type, viewable_id, user_id], so should
be a 3 column index?
My question is not really Rails related, but I am hoping that I will
some advice from other fellow Web developers.
Thanks a lot.
Read my blog at: http://cuttingtheredtape.blogspot.com/
| Great wits are sure to madness near allied,
| And thin partitions do their bounds divide.
| (John Dryden, Absalom and Achitophel, 1681)