[Announce] Database Optimizer plugin

[bobertuk]

Still the same. I noticed that C:\ProgramData\Squeezebox\Cache\InstalledPlugins\P lugins\LMSdbopt/install.xml contains <version>0.0.1</version>

Could that be the problem? Could the cache at your end contain the wrong version?

I just stopped LMS, edited <version>0.0.1</version> to <version>0.0.2</version>, restarted LMS and that seems to have worked, although I now don't know which version is really running. Is it v0.0.1 or v0.0.2?

[Roland0]

Still the same. I noticed that C:\ProgramData\Squeezebox\Cache\InstalledPlugins\P lugins\LMSdbopt/install.xml contains <version>0.0.1</version>
Could that be the problem?

Could very well be - it's certainly incorrect, even though my local installation didn't complain.
Anyway, I've uploaded a new .zip

[manx]

last version working for me at least, on debian buster. many thanks for this

edit: just for clarity, previous versions of 0.0.2 were not updating

[bobertuk]

Could very well be - it's certainly incorrect, even though my local installation didn't complain.
Anyway, I've uploaded a new .zip

That seems to have worked. I guess it was a cache problem.

Thank you

[mamema]

gotop or bottom have binaries for most platforms. You could add one of them to your container.

neither of both are working on Synology with the provided binaries. So i've installed htop in the container.

I do not see more than one core used. 25% overall and the container is at 100% if i check within the container itself.

...and for whatever reason without changing anything else i'm back at my long running trackstst cycles, runs again now for about 1.5 hours and still is running

[philchillbill]

I just updated LMS on my Ubuntu NUC to 8.2 and also added your plugin. The UI feels much snappier, especially in iPeng with loading thumbnails for cover art in the New Music view. Nice work !

A new and changed rescan of a DB with 70K tracks took 42 seconds. The system has an SSD but the music files are on an 8TB HDD.

[Roland0]

I just updated LMS on my Ubuntu NUC to 8.2 and also added your plugin. The UI feels much snappier, especially in iPeng with loading thumbnails for cover art in the New Music view. Nice work !

A new and changed rescan of a DB with 70K tracks took 42 seconds. The system has an SSD but the music files are on an 8TB HDD.

Thanks for the feedback.

I'm still fiddling with some of the parameters (cache sizes, mainly). Currently, they should be fine for ~1-2GB free memory.
However, if enough people with different requirements use this (probably unlikely...), it might make sense to add some kind of configuration mechanism.
Another idea would be to add an auto max config, which simply sets the caches to the sizes of the databases (although my artwork db currently has 1,2GB, so for a small system this may not be such a great idea)

[mherger]

> I'm still fiddling with some of the parameters (cache sizes, mainly).
> Currently, they should be fine for ~1-2GB free memory.

I'll have to play with this, in particular with the imageproxy.db, too:
MAI makes heavy use of it to cache artist artwork etc... Are you using MAI?

[Shozzer]

Hi

Only SQLite is supported, don't install this if your LMS uses MySQL.

I am running LMS 8.1.1 on Windows 10. How do I ascertain if I am using MySQL or SQLite? There are folders for both within Squeezebox\server.

Thanks.

Steve

[mherger]

> I am running LMS 8.1.1 on Windows 10. How do I ascertain if I am using
> MySQL or SQLite? There are folders for both within Squeezebox\server.

If you don't know what you're using, you're using SQLite :-)

MySQL really only is there for legacy reason. There might be some users
of it, but it requires manual configuration. Therefore you'd know about it.