View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005526 | MMW v4 | Main Panel/Toolbars/Menus | public | 2009-04-21 09:16 | 2009-05-08 17:57 |
| Reporter | Ludek | Assigned To | |||
| Priority | immediate | Severity | minor | Reproducibility | sometimes |
| Status | closed | Resolution | suspended | ||
| Product Version | 3.1 | ||||
| Fixed in Version | 3.1 | ||||
| Summary | 0005526: Expanding 'Title' node can freeze MM for minutes on some systems | ||||
| Description | Start MediaMonkey and then expand the Title node. The first time it can take a long while. Any subsequent openings of the Title node are a lot faster due to caching. Studing the Lowlander's log I found out that this SQL: SELECT DISTINCT upperw(substr( songtitle, 1, 1)) AS letter takes the time and makes MM unresponsive for 3 minutes!, it takes only 0.2 seconds on my 10k tracks DB, but Lowlander owns 800 MB's DB with 150k tracks. | ||||
| Additional Information | http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=38649 | ||||
| Tags | No tags attached. | ||||
| Fixed in build | 1238 | ||||
|
|
Note that for MM 4.0 we could change the design and keep another SQL table that would only contain the letters. That way the expanding of main 'Title' node would be just about selection from table with tens of rows. Another way is to add a new DB field to the Songs table that would keep the letter's ordinal value. |
|
|
I have got the Lownlander's DB and done a trick that seems to solve this issue for MM 3.1. Nevertheless the full solution for MM 4.0 should be one of the suggestions in my previous note. |
|
|
Verified 1244 |
