uralbash / sqlalchemy_mptt

SQLAlchemy nested sets mixin (MPTT)
http://sqlalchemy-mptt.readthedocs.io
MIT License
196 stars 32 forks source link

rebuild_tree performance issue - Takes too much time #83

Open akhil018 opened 10 months ago

akhil018 commented 10 months ago

The rebuild_treeoperation in SQLAlchemy-MPTT is experiencing performance problems and taking an unexpectedly long time to complete, particularly when dealing with large datasets. This issue significantly impacts the usability and efficiency of the library.

Expected Behavior: The rebuild_treeoperation should complete within a reasonable time frame, even as the size of the dataset grows.

Actual Behavior: The rebuild_tree operation is taking an unreasonably long time, especially noticeable when dealing with larger datasets, adversely affecting the overall performance of the library.