On Mon, 28 Jul, Michael Herger wrote:

> >> What settings do you have in Einstellungen/Erweitert/Leistung:
> >>
> >> - Plattenhüllen Grössenanpassung
> >
> > Plattenhüllen lokal in Logitech Media Server anpassen
> 
> Change this. It's slower than the online image proxy and does use the 
> imgproxy.db you're seeing. Might be another reason for the large
> number of cached items.

And I thought a local proxy/cache has to be faster ...

> It's an option for those who don't want or cannot use mysb.com to
> resize images. But it's off by default and should only be used by the
> brave ;-).

I considered myself "brave". Obviously I should not. ;-D

> >> - Konfiguration des Datenbankspeichers
> >
> > Normal
> 
> Autsch! Change this to max (with your amount of memory). It might
> help as well.

Ok, done.

> >> - Spezifikation für Zwischenspeicherung
> >
> > Don't seem to have that. I have "Plattenhüllen zwischenspeichern"
> > which is set to "Plattenhüllen zwischenspeichern". :-}
> 
> "Spezifikation" is a number of parameters like 75x75_p or similar.

I don't see such an option here (at least not under
"Einstellungen/Erweitert/Leistung" using 7.9.0~1403985527).

> >    sqlite> pragma page_count;
> >    2511663
> >    sqlite> pragma freelist_count;
> >    511826
> >    sqlite> pragma auto_vacuum;
> >    0
> 
> Ok, you might want to run vacuum manually.

Will do that and report tomorrow.

> Shut down LMS, open imgproxy.db in sqlite3, run "vacuum;", prepare
> for a looong break, as this can take a while.

Would it be an option (and faster?) to just delete the imgproxy.db
before restarting LMS?

-- 
Stefan Bellon
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta

Reply via email to