@EVILRipper wrote:
Could you tell me -why- the first songs start at the album Cheshire Cat?
Or at least any idea -how- it scans that album first??
Maybe it stores indexes in a balanced tree, and the output is the result of a traversal in something other than in order. Not sure. It’s a mystery of sqlite.
You can try the other sqlite and see if it does any different — like sqlite3 rather than sqlite2, for example. Perhaps it returns results in a different order.
— Ron