laravel-nestedset
laravel-nestedset copied to clipboard
Slow update of records in the table
We're heavily using this library as part of our application and we notice a slowdown in updating the _lft and _rgt. Below is the sample code that I saw in our logs
update traces set _lft = case when _lft >= 214017 then _lft+2 else _lft end, _rgt = case when _rgt >= 214017 then _rgt+2 else _rgt end where (_lft >= 214017 or _rgt >= 214017)
@nicopenaredondo We faced same issue, slowness on creating and deleting comments. Did you find any way? Can you share? Thanks in advance.