If sqlite behaves as other relational engines do, then the Artist list would be served up completely from the index in pre-sorted order without having to read the underlying table.
I guess that depends on the queries used? Doing a SELECT * FROM … wouldn’t have that advantage 😉 But indeed, I just tested, and my Soundbridge can access the DB much faster now 😯 Shiny 😮
Yes, you’re absolutely right. Thank you for making that clarification. I should have said that any query whose result set can be satisfied by an index will experience faster performance.