Scans seem slow? web, SBC ui slow? how to make them faster! vote for this bug!

[MrSinatra]

if you feel that scans take too long, the UI's are too slow, read this thread:

http://forums.slimdevices.com/showthread.php?t=60682

and vote for this bug:

http://bugs.slimdevices.com/show_bug.cgi?id=14921

hopefully, eventually the optimization will be automated at install. in the meantime, there are the instructions, but BEWARE, this is AT YOUR OWN RISK!!! make copies FIRST of everything you change!!! don't do this unless you feel comfortable trying it, but if you do you should notice substantial improvements.

a "win-xp-dummies" guide to installing moonbases tweaks, but easily translated to most windows/slimware.

make sure you know your last scans stats prior to any of this!

1. download moonbase's my.tt.txt from post 18

http://forums.slimdevices.com/showpo...0&postcount=18

2. stop SBS and exit all SBS functions. (check task manager to be sure all squeeze stuff, slim stuff, mysql/mysqld, etc... is gone/closed)

3. find the SBServer cache folder, which is normally located at:

C:\Documents and Settings\All Users\Application Data\Squeezebox\Cache

and delete a file called my.cnf which might appear as a shortcut w/an icon of a monitor simply named: my

4. backup your current copy of my.tt which is normally located at:

C:\Program Files\Squeezebox\server\MySQL

to a safe place. then delete it from its original location.

5. copy moonbases downloaded file to the my.tt original location.

6. rename moonbase's file to remove the .txt at the end.

7. if desired, reboot the computer (safer). if not, simply restart SBS.

8. run a full "clear and rescan" and see how much better it is, then report both results back here to this thread.

moonbase's file assumes you have at least a gig of ram and other reasonably new hardware. part of what we want to know is what hardware it works well with, and what hardware it doesn't.

[verypsb]

Is this not too much work, when there soon will be a switch to SQLite from MySQL?

[signor_rossi]

Originally Posted by verypsb

Is this not too much work, when there soon will be a switch to SQLite from MySQL?

What is soon?
The release of the Touch?

[MrSinatra]

i'm not 100% positive, but i believe there will be a variation of this applicable to the forthcoming SQLite ver of SBS. AndyG needs our data in order to implement the feature.

[verypsb]

System:
Windows 2008 R2 (x64), 4GB, Pentium Dual-Core E5200@2.50Ghz, 99% .flac, OS on 1 single drive, music files on 2 drives in RAID0 (Intel ICH8R/ICH9R/ICH10R/DO SATA RAID Controller)

Total Tracks: 35,792
Total Albums: 3,445
Total Artists: 1,033
Total Genres: 151
Total Playing Time: 2767:39:29

Music Scan Details (Before)
Directory Scan (35792 of 35792) Complete 00:35:37
Playlist Scan ( of ) Complete 00:00:00
MusicIP Import (35321 of 35321) Complete 00:24:03
Merge Various Artists (3309 of 3309) Complete 00:01:27
Artwork Scan (3445 of 3445) Complete 00:24:36
The server has finished scanning your music collection.
Total Time: 01:25:43 (Monday, 26 October 2009 / 19:24)

Music Scan Details (After)
Directory Scan (35792 of 35792) Complete 00:33:56
Playlist Scan ( of ) Complete 00:00:00
MusicIP Import (35321 of 35321) Complete 00:13:57
Merge Various Artists (3309 of 3309) Complete 00:01:26
Artwork Scan (3445 of 3445) Complete 00:24:34
The server has finished scanning your music collection.
Total Time: 01:13:53 (Monday, 26 October 2009 / 20:56)

[MrSinatra]

interesting... your directory scan part only improved a min or two, but your musicip part improved by around 10min. in my case, i don't use musicip, but my directory scan improved by about 9min. i think other people will get better results since my music is on an ext usb2 drive.

hard drive cranking, any issues like that? webui response better?

[verypsb]

Originally Posted by MrSinatra

webui response better?

Yes, the WebUI looks more responsive.

[raven22]

where can i find the my.tt file in a debian install?


edit: found it! it is in /usr/share/squeezeboxserver/MySQL

[MrSinatra]

Originally Posted by raven22

where can i find the my.tt file in a debian install?

i don't know, isn't it roughly in the same spot? did u try reading the whole thread at the first link i posted?

[mherger]

> where can i find the my.tt file in a debian install?

On Linux systems the pre-installed database server is being used. The changes discussed would need to be applied to the main mysql instance. Configuration will influence other apps using it too. Be sure what you're doing.

Configuration files most likely are in /etc/my.cnf or similar.