![clementine music player debian clementine music player debian](https://images.pling.com/img/00/00/53/18/35/1288971/8a32c85d68e188c31ec1aef9f7aeeecabc99.png)
In sqlite 3.8 however, there seems to be some kind of type conversion going on when the "=" operator is used which slows the query down to a crawl. In this regard, the above query should not be a problem, and in sqlite 3.7 there is none.
![clementine music player debian clementine music player debian](https://ubuntuhandbook.org/wp-content/uploads/2019/12/debi-clementine.jpg)
This can be seen by running "SELECT typeof(effective_compilation) FROM songs ". When we put integers in this column, they will have the storage class "integer". forced_compilation_on) are created with "INTEGER NOT NULL DEFAULT 0".įrom what I understand from the documentation of sqlite's type affinity, the column "effective_compilation" will have type affinity NONE. The column effective_compilation is created with the properties "NOT NULL DEFAULT 0". The problem lies in the clause "effective_compilation = 0". On my computer this query takes 20 seconds with sqlite 3.8.1 compared with SELECT DISTINCT artist FROM songs INNER JOIN songs_fts AS fts ON songs.ROWID = fts.ROWID WHERE fts.songs_fts MATCH "w*" AND effective_compilation = 0 AND unavailable = 0 When we search the library for every word that starts with "w" the following query is performed: I believe I have found the cause of this issue.
#Clementine music player debian how to
Maybe there is a correlation ? I removed gstreamer1.0-plugins* (I still have gstreamer0.10-plugins*) but nothing new.Īny Idea how to fix my clementine installation ? thanks in advance I rebuild the library as usual but then it is extremely slow.
![clementine music player debian clementine music player debian](https://149366088.v2.pressablecdn.com/wp-content/uploads/2017/01/Screen-Shot-2017-01-09-at-18.54.03.png)
Today, when i search something on my Clementine library, CPU usage go to 100% and It takes like 10min to apply the filter. When I search something on the library, it is instant. I have Clementine installed from repository on my Debian Jessie (clementine 1.1.1+dfsg-2)Ĭlementine is extremely fast usualy.