Displaying 1 result from an estimated 1 matches for "url_phrase".
Did you mean:
url_parse
2006 Apr 29
2
Seeing performance problems with has_many :through relation
...izing MySQL databases and I am wondering if I
need to tweak the way the tables are structured or if its something I
can fine-tune in rails.
If it helps the indices were defined on the relations table as follows:
CREATE unique index phrase_url on relations (phrase_id, url_id)
CREATE unique index url_phrase on relations (url_id,phrase_id)
( started with just the first index and added the second when these
issues started popping up )
I am hoping someone can spot the problem and suggest a modification to
either the DB or the relationship in rails that leads to a solution.
Thanks for any suggestions...