FS#13026 - Clip+ database is slow

Attached to Project: Rockbox
Opened by John (plsng) - Tuesday, 03 February 2015, 20:02 GMT
Task Type Bugs
Category Database
Status Unconfirmed
Assigned To No-one
Operating System Sansa Clip+
Severity Medium
Priority Normal
Reported Version Daily build (which?)
Due in Version Undecided
Due Date Undecided
Percent Complete 0%
Votes 2
Private No


Using build 95fdad5.

The database on the Clip+ is very slow in loading: when you select an artist/album/..., it takes about a second or two for the list of albums/tracks/... to show up. On the latest stable release this is instant. This problem has likely been around since;a=commit;h=7d1a47c
This task depends upon

2017-12-28: A task closure has been requested. Reason for request: Fixed in a recent commit.
Comment by Michael Sevakis (MikeS) - Friday, 29 May 2015, 21:49 GMT
Yea, quite possible that has something to do with it. You said "likely" but didn't confirm. Yes, it disables some code for caching dircache pointers for the time being because of the dircache changes so, as a result, I wouldn't at this point consider it a bug but just a prompt to continue the project.

ETA: I haven't noticed that short lists take much time to populate. How many items in a list a we talking about?
Comment by John (plsng) - Saturday, 30 May 2015, 13:45 GMT
Opening the artist list (like pretty much everything else) is instant, but once you go a level deeper, i.e. to albums by a selected artist, the list of that artist's albums doesn't show up instantly but takes a noticeable amount of time, however the amount of items in the list doesn't seem to have a large impact on this as a list of 1 item and a list of 40 items took about the same amount of time to show up.

Also, possibly the most noticeable slowness is when adding anything from the database to a/the playlist. On the last stable build, this is instant (adding 1000 songs takes less than a second), but on the daily builds this takes a lot of time (adding 1 song already takes more than a second, adding 1000 takes excruciatingly long, about 20 seconds at least). However, this slowness in adding to playlists only occurs when you use the 'add to playlist' menu option. When you just click on one of the songs to start playing, the playlist is instantly populated with all the album's tracks.

Hopefully this has helped a bit in finding the cause.
Comment by John (plsng) - Sunday, 22 May 2016, 21:29 GMT
Comment by joshua (sigrokBlack) - Sunday, 21 August 2016, 16:59 GMT
The same on my Ipod 6g as mentioned here:,51425.0.html
Comment by John (plsng) - Wednesday, 25 January 2017, 20:53 GMT
Two years on, nothing has changed, the database is still completely unusable. Please prioritise fixing the speed (or lack thereof) of the database.
Comment by MichaelGiacomelli (saratoga) - Monday, 01 May 2017, 21:05 GMT
This is likely fixed in the new 3.14 release and newer.
Comment by John (plsng) - Tuesday, 02 May 2017, 09:12 GMT
Good to see a new major release, but I just checked and unfortunately it is not fixed. Maybe it got slightly better, but it's still unusable in its current state.
Comment by John (plsng) - Thursday, 28 December 2017, 12:15 GMT
Great news: a recent commit seems to have fixed this problem on the Clip+ and the Clip Zip. Adding hundreds of songs to a playlist is now near instant again, as it used to be. I don't have a Fuze to test right now, but assuming it was the same bug, both this and can now be closed. Many thanks!