On Aug 31, 2010, at 7:46 PM, Wirrunna wrote: > > andyg;571278 Wrote: >> On Aug 22, 2010, at 7:47 PM, copperstate wrote: >> >>> >>> Setting the Performance/Database Memory Config entry to "High" >> whilst >>> using MySQL does not work: >> >> Oops, I forgot to check the file in. :) > > andyg, is this in yet? Does it make a permanent change or just set > these parameters while SBS has the DB open? > Running Version: 7.6.0 - r31258 on WIN XP and Settings / Advanced / > Performance / Database Memory Configuration set to High and applied do > not appear to change the memory usage. > Checked the ...Cache\Squeezebox.db DB Settings with > http://code.google.com/p/sqlite-manager/ for Firefox before and after > applying the High mem config and the cache size remained at 2000 and > Temporary Store was still default. > Changing the cache settings with SQLite manager to your recommended > 20000 pages appears to make the web interface performance crisper.
It's not permanent in the database, but only at runtime, i.e. the pragmas are set every time you start the server. _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
