Improving performance for "New Music" function

[Mnyb]

Just added 10 albums did a rescan and everything is still fast, comes up quite quick in the interface.

So it's either the memory setting or statistics. I should have only change one not the other. doh!

Or it's something that gets worst over time, and I need to add more music and do more scan for new and changed.

I run 7.7.2 and have found that over time the dB clog up and you have to do a clear and rescan the telltale sign is that it suddenly crash at files it usually accepted, or simply never finish correctly hence the analyse phase is never done , currently I'm the stage that new and changed never reports that it is finished you have to abort or restart server of course the new music is still found so the scan really worked but something else gets wrong . So I'm up for the monthly clear and rescan everything ?

[Jeff Flowerday]

Ok, just rebooted my server 20 minutes ago.

Went to new music and it's 30 seconds now with no response.

...

Finally came back, event log show this error message.

[12-02-28 11:16:57.0088] Slim::Networking::IO::Select::__ANON__ (147) Error: Select task failed calling Slim::Web::HTTP:rocessHTTP: illegal file descriptor or filehandle (either no attached file descriptor or illegal value): at /<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Networking/IO/Select.pm line 150.
; fh=Slim::Web::HTTP::ClientConn=GLOB(0x771f184)

[JJZolx]

> illegal file descriptor or filehandle

A common problem around here:

https://www.google.com/search?ix=sea...bih=737&ix=sea

Could it be an anti-virus issue?

[Jeff Flowerday]

> illegal file descriptor or filehandle

A common problem around here:

https://www.google.com/search?ix=sea...bih=737&ix=sea

Could it be an anti-virus issue?

No antivirus on my server.

[JJZolx]

It's such a common error that it's also hard to say whether or not it has anything to do with the problem you're seeing.

I'd still like to know if it's only 'New Music'. This has been reported before in the forums.

Are you running any third party plugins?

[Jeff Flowerday]

It's such a common error that it's also hard to say whether or not it has anything to do with the problem you're seeing.

I'd still like to know if it's only 'New Music'. This has been reported before in the forums.

Are you running any third party plugins?

I've shut off pretty much every default plug in I didn't need, which is the majority of them.

Only third party plug in I'm running is "Not So Sirius Radio"

[JJZolx]

Well, you can always go back to using MySQL. 105,000 tracks just may be too much for SQLite.

http://forums.slimdevices.com/showth...432#post668598

In addition to the instructions in the post above, you'll need to manually install DBD::mysql, since it's been removed from the server code.

C:\Perl\bin>ppm install DBD-mysql

http://code.activestate.com/ppm/DBD-mysql

[Jeff Flowerday]

Well, you can always go back to using MySQL. 105,000 tracks just may be too much for SQLite.

http://forums.slimdevices.com/showth...432#post668598

In addition to the instructions in the post above, you'll need to manually install DBD::mysql, since it's been removed from the server code.

C:\Perl\bin>ppm install DBD-mysql

http://code.activestate.com/ppm/DBD-mysql

I hope this isn't the case, the two advantages LMS and squeezeboxen had over Sonos was library size and 24/96 in the touch.

I'm hoping simaudio's solution turns out to be decent, I'm not too happy with Logitech's direction with this product lately.

[JJZolx]

I'm not too happy with Logitech's direction with this product lately.

It does seem to be circling the drain.

[bobkoure]

I've noticed marginally longer times for my music / new music when the server's been restarted. (Maybe 8 seconds instead of three.)
I have my cache on ramdisk, which it sounds like you are doing too (?)
75K tracks, 200 tracks new music limit, atom 525 running win 2k3