whether it is MySQL or SQLite, it seems to me that all the settings would be best set by some kind of "auto tuner." surely there is some script out there that could benchmark your cpu, ram, hard disk speeds, and so on and then take into account your library size, art settings, etc... and determine from that the most optimal settings for your SBS install?
it could be a plugin, only to be run after at least one "normal, default" scan has taken place, (so it had the library stats). it could also report back the stats, ie. hardware, file types/counts, etc... and that info could be aggregated for public knowledge. maybe this is a start: https://launchpad.net/mysql-tuning-primer of course, the tuner would have to assume the machine was ONLY used for SBS, and not multitasking. -- MrSinatra www.lion-radio.org using: sb2 & sbc (my home) / sbrec & ipeng (parent's home) - sbs 7.5.2b - win xp pro sp3 ie8 - p4(ht) 3.2ghz, 2gig ram - 1tb wd usb2 raid1 - d-link dir-655 - 43k+ mp3 ------------------------------------------------------------------------ MrSinatra's Profile: http://forums.slimdevices.com/member.php?userid=2336 View this thread: http://forums.slimdevices.com/showthread.php?t=81310 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
