MrSinatra;573700 Wrote: > 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, I don't think this is necessary. If andyg were to add a third option to his Performance/Database Memory Config of "Set Cache to DB size" he would satisfy those of us with huge amounts of available memory. My experience so far with allocating a cache size equal to the DB size is that memory use by SQUEEZ~3.EXE reaches a peak and floats around near that peak while never reaching the maximum allocation available. It is also hard to quantify the performance gain while browsing, I suspect there is a placebo effect happening which makes me think that browsing is crisper. WIN XP SP3, Version: 7.6.0 - r31275 -- Wirrunna A camel is a racehorse designed by a committee. ------------------------------------------------------------------------ Wirrunna's Profile: http://forums.slimdevices.com/member.php?userid=3225 View this thread: http://forums.slimdevices.com/showthread.php?t=81310 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
