Use 1586 or 1696, nothing in between

[Anonymous]

Thanks for the tips. I read some previous threads and saw information about indexing the database by artist by doing

sqlite> create index idx_artist on songs(artist);

in sqlite (actually using sqlite3). I’ve done that, but I’m wondering if there is also a way to create a similar index that would help load a large playlist. I’ll admit that I don’t really understand the database organization here, so it’s not clear to me what the right sort of index (if any) would be.

Given the slow CPU and small amount of memory (32 MB) in my NAS, I may just be out of luck, but let me know what you think.

Thanks in advance for any clarifications.

[rpedde]

@elnjensen wrote:

Thanks for the tips. I read some previous threads and saw information about indexing the database by artist by doing

sqlite> create index idx_artist on songs(artist);

in sqlite (actually using sqlite3). I’ve done that, but I’m wondering if there is also a way to create a similar index that would help load a large playlist. I’ll admit that I don’t really understand the database organization here, so it’s not clear to me what the right sort of index (if any) would be.

Given the slow CPU and small amount of memory (32 MB) in my NAS, I may just be out of luck, but let me know what you think.

Thanks in advance for any clarifications.

Not really, the query for playlists is just plain ugly on a memory limited device.

Hopefully, the new db backend will speed that up. Watch nightlies!

[Anonymous]

Hopefully, the new db backend will speed that up. Watch nightlies!

Thanks! Speaking of that, is there any way to be notified of new nightly builds or other releases (like a mailing list or RSS feed)? I looked around the website but didn’t find anything.

[rpedde]

@elnjensen wrote:

Hopefully, the new db backend will speed that up. Watch nightlies!

Thanks! Speaking of that, is there any way to be notified of new nightly builds or other releases (like a mailing list or RSS feed)? I looked around the website but didn’t find anything.

Err, there was an rss feed on the *old* nighlies page, but I haven’t moved it to the new one. I’ll see if I can get that up tonight.

– Ron

[Anonymous]

You are right.

I am used to thinking about this.

[Author]

Posts