search

rgarner / semantically-taggable

Sort-of-fork of acts_as_taggable_on, but where Tags exist in a more formal semantic Scheme
MIT License
4 stars 1 forks source link

Fix for :any and :exclude has introduced perf issues #29

Open rgarner opened 13 years ago

rgarner commented 13 years ago

These can be mitigated by caching (lots) in the client app, but the IN queries are causing a lot of grief. Need to EXPLAIN SELECT much and do better.

rgarner commented 13 years ago

Could consider adding to the tag_parentages table an extra record with identical parent_tag_id and child_tag_id with a distance of 0. This would allow simple JOIN rather than IN queries. Need to check it doesn't introduce regressions around :