24th February 2007 at 6:50 pm #8739
$ sqlite /opt/var/mt-daapd/songs.db
sqlite> create index idx_artist on songs(artist)
That should build the index, and it should use that index when doing browses by artist.
And now, when I want to rebuild this structure because I’ve added a lot songs, how do I update this?