Since the beginning of the 1.4 cycle I'm having trouble with my (SQLite based) music database. I think in the last few months I have started over again at least 20 times with my playcounts, ratings and scores 

Symptoms are always the same:

Without any discernible reason, i.e. noupgrade of Amarok or another relevant software package, crash or so, one of the following happens - or not - it may work flawlessly for some time, then suddenly happen again:

- Playlist is full when starting, but Amarok complains that the XML is invalid
- Path to collection is suddenly lost and must be re-entered
- Playlist (usually about 2500 songs) suddenly contains only the first 200 or so songs
- Ratings, playcounts and scores are simply lost. I can start them over again, but maybe at the next try (starting Amarok after the next reboot) the "old" values have miracously returned and everything works again as expected
- When filtering the playlist by typing characters in the search field, the UI (not the playback) often hangs for half a minute or so after typing in the first few letters
- Playlist (rather big in my case) seems to be rescanned after every new boot of the computer (after that, amarok starts again without rescanning until the next boot)

I use SUSE 10.2 Factory and the packages provided by Guru.

This is getting rather annoying!!!!

The problem is your big playlist. This takes times to save, and KDE will sometimes kill Amarok before it's properly shut down. Solutions:

1) Upgrade to 1.4.3. Playlist saving has been made much faster.
2) Keep a shorter playlist. No need to stuff 2500 tracks in there.
3) Shut down Amarok before shutting down KDE.

Yes, I thought so...

I am currently using 1.4.3 - problem still persisting. Once the statistics are lost, they only get back (if at all) when restarting the computer. Leaving Amarok and starting it again doesn't work.

I usually have my music playing in the background all day, random shuffle over all my tracks, so I WANT it that big. I am the user, and the user is king ))).

I don't think that Amarok should be disturbed by longer playlists, that's so "640KB should be enough for everyone"-ish . Same goes for shutdown. Yes, it's true, when I shutdown the computer, I often have Amarok still playing, as it is expected behaviour that shutting down KDE will cleanly shutdown any running KDE applications, too.