Improve library performance on large collections
Bug #672762 reported by
RAFFI TEA
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mixxx |
Fix Released
|
Medium
|
RAFFI TEA |
Bug Description
On large music collections (> 50.000 files) and slower computers the library becomes unresponsive. During the SQL query process the GUI freezes for some seconds.
Changed in mixxx: | |
importance: | Undecided → Medium |
status: | New → Confirmed |
Changed in mixxx: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
This is really interesting and might contribute to the problem.
When selecting playlists, crates or other root models, BaseSqlModel: :select( ) is called 3-4 times. This is inefficient for <LibraryFeature >TableModels that hold large data sets.
How to reproduce: :select( )
* Add a qDebug() to BaseSqlModel:
* Execute Mixxx and click on some playlists, crates, etc
This is probably because Mixxx does also call restoreSearch() on sidebar item changes which fires a select as well.