I found myself complaining about the slow speed of Amarok. Everything would lag, from playing a song to adding a song to the playlist. Then i remembered when I was setting up Amarok that it let me chose a database, and said the faster ones required extra set up. Of course, I chose the no set up required but slow speed option (SQLlite).
Now, I wanted to switch. And boy am i glad. Everything works as fast as it should.
sudo apt-get install mysql-server mysql-client
now this (replace PASSWORD with your password)
mysqladmin -u root password PASSWORD
mysql -p -u root
CREATE DATABASE amarok;
GRANT ALL ON amarok.* TO amarok@localhost IDENTIFIED BY ‘PASSWORD_CHANGE_ME’;
In Amarok, go to settings> configure Amarok
Use the following settings:
Password: Your Password
You’re done! Enjoy the speediness!