Displaying 1 result from an estimated 1 matches for "guidepage".
Did you mean:
guidenace
2006 Jul 18
0
non-optimal sql
...om tagpairs where id = 33;
delete from tagpairs where id = 34;
delete from tagpairs where id = 35;
...
insert into tagpairs (...) values (...);
insert into tagpairs (...) values (...);
...
commit
This would be better as:
delete from tagpairs where obj_type = ''guidepage'' and obj_id = 1;
insert into tagpairs (...) values (...);
...
In my case, I''m using a polymorphic association. However, the basic idea applies to a non-polymorphic association. We can and should delete members of the association based on the association key field having...