Slow on move_to_child_of
Closed this issue · 2 comments
xinlangzi commented
I create inventory_item then call move_to_child_of, then generate the below SQL which is very slow.
Anyone can help?
SQL (3642.6ms) UPDATE "inventory_items" SET "lft" = CASE WHEN "lft" BETWEEN 16948 AND 144458 THEN "lft" + 144460 - 144458 WHEN "lft" BETWEEN 144459 AND 144460 THEN "lft" + 16948 - 144459 ELSE "lft" END, "rgt" = CASE WHEN "rgt" BETWEEN 16948 AND 144458 THEN "rgt" + 144460 - 144458 WHEN "rgt" BETWEEN 144459 AND 144460 THEN "rgt" + 16948 - 144459 ELSE "rgt" END, "parent_id" = CASE WHEN "id" = 75180 THEN 75179 ELSE "parent_id" END, updated_at = '2019-01-30 08:06:54.333592' WHERE "inventory_items"."id" IN (SELECT "inventory_items"."id" FROM "inventory_items" WHERE ("inventory_items"."lft" BETWEEN 16948 AND 144460 OR "inventory_items"."rgt" BETWEEN 16948 AND 144460) ORDER BY "inventory_items"."lft" ASC)
xinlangzi commented
Anyone can help?
stale commented
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.