Browsing Artists is Slow

[tkem]

Real slow. Indexing album.artists and track.artist might help, and is planned for #1 anyway...

[tkem]

Alternatively, doing a scan over album.artists and tracks.artists may be the better approach in the first place, e.g.

SELECT 'directory', artist.uri, artist.name
          FROM (
            SELECT DISTINCT artists FROM album
             UNION
            SELECT DISTINCT artists FROM track
          )
          JOIN artist on artists = artist.uri
         ORDER BY name

Indexing won't hurt, anyway...