Strange issue with project list
Added by Alexander Eriomenko over 14 years ago
1. After adding new project something happened with projects list sort. Projects stay shuffled.
2. Through mysql i've reset lft and rgt to to sequential values
like that
| lft | rgt |
| 1 | 2 |
| 3 | 4 |
| 5 | 6 |
and so on
3. Also i've reset the parent_id column to null (had only 3 nested projects) to reset projects tree
4. After that all works, but very slow i think because of my changes
Could somebody explain what should be in lft and rgt columns of projects table?
What may be source of performance problems?