Reply To: Sqlite3 on NSLU2 with debian etch

#16136
rpedde
Participant

@caribou wrote:

Hi, it’s been a long time that i am running firefly media server on my NSLU2 (debian etch arm) with version svn-1376 (the one provided with apt-get) using sqlite3 as database backend. I had really good performances for about 28K songs but for two reasons, I wanted to migrate to a more recent version (svn-1586 or svn 1696):

  • upgrade for security reason
  • have a version with corrected bug when adding static playlist with web interface

I then downloaded the two versions (mt-daapd_0.9-svn-1586_etch_arm.deb and mt-daapd_0.9-svn-1696_etch_arm.deb) from both

But none of them seems to have the sqlite3 support enabled which make me use sqlite instead. The problem is that sqlite is much more slow for me on the slug (e.g. select count(1) from songs can take about 40sec.!) So even simple requests (e.g. /rsp/info) take a long long time 🙁
What can I do to have an sqlite3-enabled version without having to compile it myself ?
Thanks in advance for your answers…
–caribou

Wow. you are right. The package is built with –enable-sqlite3, but sure enough, it isn’t linked to sqlite3.

Strange.

I’ll see if I can at least work up a package for that this weekend.

— Ron