laravel-nestedset icon indicating copy to clipboard operation
laravel-nestedset copied to clipboard

Slow update of records in the table

Open nicopenaredondo opened this issue 5 years ago • 1 comments

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 avatar Jun 15 '20 06:06 nicopenaredondo

@nicopenaredondo We faced same issue, slowness on creating and deleting comments. Did you find any way? Can you share? Thanks in advance.

hasnatbabur avatar Aug 08 '22 18:08 hasnatbabur