Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
Bronx wrote: > Hello Michael > Here's a small update for the fulltext-search under 8.3. > I have added in the last days in three stages with rescans about 50 > albums, in each case checked before with the fulltext-search whether > they are already present, searched about 10x targeted tracks in > individual playlists and as a result everything seems to me error-free > and plausible. So I have no special incidents to report about the > changes in the fulltext-search under 8.3.0, again, thank you very much. > Bronx > > > I just wanted to confirm that untill today I added hundred of files an > did dozens of FTS'es without any errors or omissions as far as I can > recognise. The optimised FTS under 8.3 seems to be 100 % OK. > Thanks to Michael. > Bronx Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
mherger wrote: > I've committed a change to the LMS 8.3 dev version which... looks too > good to be true! It brought down FTS indexing time from somewhere around > 45 minutes to about 3 minutes. Scanning your 20k playlist previously > took about 16 minutes alone, and memory consumption spiked around 9GB. > Now it takes seconds, and memory stays around 1GB (with memory set to > Maximum). > > It's late. Maybe I'm missing something obvious. So please give the > search feature using FTS some thorough testing! > > New builds should be out shortly: > http://downloads.slimdevices.com/nightly/index.php?ver=8.3 > > Oh: and you'll have to rescan your collection to make this work (no wipe > required). Hello Michael Here's a small update for the fulltext-search under 8.3. I have added in the last days in three stages with rescans about 50 albums, in each case checked before with the fulltext-search whether they are already present, searched about 10x targeted tracks in individual playlists and as a result everything seems to me error-free and plausible. So I have no special incidents to report about the changes in the fulltext-search under 8.3.0, again, thank you very much. Bronx Translated with www.DeepL.com/Translator (free version) Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
Bronx wrote: > Will do! Thank you. > Bronx Perfect! Great! The rescan under 8.3.0 was completed without errors. My 46 playlists were all recognized, are listed in the menu and can be played. BTW: The biggest playlist with 20'000 tracks starts with all 20'000 tracks without any errors after exactly 8 seconds loading time (first time, then it takes about 4 seconds). And as far as I can see, playlists with searched tracks are also found and displayed in the search results (although I hardly need this per se). I've done about 20 full-ext searches and everything seems plausible. I will definitely keep testing the version and get back to you if I notice anything. Thank you very much! Bronx Details zum Medien-Scan Dateien/Verzeichnisse werden erkannt: F:\Eigene Dateien\Eigene Musik (682414 von 682414) Beendet 00:31:13 Dateien/Verzeichnisse werden erkannt: G:\Eigene Dateien\Eigene Musik B (516018 von 516018) Beendet 00:29:48 Neue Musikdateien werden durchsucht: G:\Eigene Dateien\Eigene Musik B (1 von 1) Beendet 00:00:00 Wiedergabelisten werden erkannt: G:\Eigene Dateien\Playlists (46 von 46) Beendet 00:00:01 Volltext Index erstellen (7 von 7) Beendet 00:09:37 Musiksammlungs-Ansichten erstellen (32 von 32) Beendet 00:05:57 Nach aktualisierten Plattenhüllen suchen (518 von 518) Beendet 00:00:29 Plattenhüllen werden zwischengespeichert (276 von 276) Beendet 00:00:53 Datenbank Optimierung (2 von 2) Beendet 00:14:18 Der Server hat das Durchsuchen Ihrer Medienbibliothek abgeschlossen. Laufzeit: 01:32:16 (Donnerstag, August 19, 2021 / 9:51) Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
mherger wrote: > I've committed a change to the LMS 8.3 dev version which... looks too > good to be true! It brought down FTS indexing time from somewhere around > 45 minutes to about 3 minutes. Scanning your 20k playlist previously > took about 16 minutes alone, and memory consumption spiked around 9GB. > Now it takes seconds, and memory stays around 1GB (with memory set to > Maximum). > > It's late. Maybe I'm missing something obvious. So please give the > search feature using FTS some thorough testing! > > New builds should be out shortly: > http://downloads.slimdevices.com/nightly/index.php?ver=8.3 > > Oh: and you'll have to rescan your collection to make this work (no wipe > required). Will do! Thank you. Bronx Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
mherger wrote: > > Yes, this is the library with a few small playlists that scan without > > errors. Will fill it up and send again. I use fulltext search > regulary, > > so this won't be a longterm option for me. > > Are you using the search eg. find a playlist by track, too? In the past > > we only stored the playlist's name and URL in the FTS index, but no > track information. One change from about a year ago now puts all track > information in the playlist index, too. This allows you to search for a > > playlist by track title, or artist of a track etc. > > If you didn't use this feature and were willing and able to edit a text > > file, you could disable this new behaviour and easily fall back to the > much faster and less memory hungry old method. It is certainly not a problem for me to continue without the playlist search by title, I 'd never use this. I have only a few playlists, which are all stored in one directory. So there is no reason to search this way. Bronx Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
mherger wrote: > > I uploaded the library.db with all 45 playlists some minutes ago. > > Additionally the playlist files. When sorting the playlist-files by > size > > I did a rescan with all the playlists up to and with size 527 KB and > > this rescan ended error free. Afterwards additionally with playlists > up > > to size 1 MB, this rescan was prematurely terminated when building > > fulltext index 4. It is not clear to me whether this is due to the > sum > > of all playlists or to a single one. So on the other hand it is clear > > that not the playlists with a size of more than 1 MB alone lead to > the > > error. That's all I can help with at the moment. > > Thanks! I'll see what I can do. Most likely this is the change that > broke the scan for you: > > https://github.com/Logitech/slimserver/commit/077e3dfe8cc9774399a7835fd1f7e9a3a92099e4 > > "Improve indexing performance on large playlists" - probably at the cost > > of memory usage... And not with that large playlists :-). Would LMS even > > be able to load a 20k tracks playlist? Hello Michael That is a very valid question. I believe that playlists with up to 20'000 have been opened and played in LMS without error message (at least started, who listens through 20'000 files? ;-)). I checked: I actually set the limit to 20'000 tracks. But of course this is an edge case, what's the point of generating such big playlists? Here is my special explanation: I open them with foobar2000 and copy the corresponding music files to other directories to distribute them on my mp3 player, my iphone or on USB stick for my car or my friends. I usually do not select such extreme playlists to play in LMS. I am quite sure that playlists up to 4'000 tracks (size around 1 MB) will play in LMS without any problems. As I said, I am an edge-case and fully understand if for me the troubleshooting effort is limited. However, for me the error seems to be related to the sum rather than the size of the playlists. Again, thank you very much. Bronx Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
mherger wrote: > > I added a small number of small playlists back to the playlist folder > > (*.m3u). These were scanned without errors. Will check occasionally > if > > the error occurs because of a specific playlist or because of the > > accumulation of a larger number of large playlists. > > > > I have uploaded library.db to your dropbox. > > Thanks! That copy only has about ten playlists. Is this the full list, > or the small number? I'd have been interested of a copy with the full > list, of course... > > BTW: you could disable the Fulltext Search plugin (if you don't need it) > > to overcome this limitation. I'm still thinking about how to be able to > > test your issue. Even with the DB file it's not easy to come up with a > good procedure. I uploaded the library.db with all 45 playlists some minutes ago. Additionally the playlist files. When sorting the playlist-files by size I did a rescan with all the playlists up to and with size 527 KB and this rescan ended error free. Afterwards additionally with playlists up to size 1 MB, this rescan was prematurely terminated when building fulltext index 4. It is not clear to me whether this is due to the sum of all playlists or to a single one. So on the other hand it is clear that not the playlists with a size of more than 1 MB alone lead to the error. That's all I can help with at the moment. Bronx Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
mherger wrote: > > I added a small number of small playlists back to the playlist folder > > (*.m3u). These were scanned without errors. Will check occasionally > if > > the error occurs because of a specific playlist or because of the > > accumulation of a larger number of large playlists. > > > > I have uploaded library.db to your dropbox. > > Thanks! That copy only has about ten playlists. Is this the full list, > or the small number? I'd have been interested of a copy with the full > list, of course... > > BTW: you could disable the Fulltext Search plugin (if you don't need it) > > to overcome this limitation. I'm still thinking about how to be able to > > test your issue. Even with the DB file it's not easy to come up with a > good procedure. Yes, this is the library with a few small playlists that scan without errors. Will fill it up and send again. I use fulltext search regulary, so this won't be a longterm option for me. Bronx Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
mherger wrote:
> > I have logged the memory usage during the rescan under 8.2.1. The
> result
> > is roughly the same as in 7.9.3. Start at about 48%, up to 58%, then
> to
> > about 68% at the end and then it stops. The fact that the usage is 3-5
> %
> > points higher may only have to do with the running performance
> monitor
> > or other background processes. The memory usage of 68% does not go
> down
> > after the abort. Scanner.log is identical to my first mail. According
> to
> > the log, the abort occurs at the completion of the 4th full-text
> index
> > (playlists).
>
> One more check you could run: how much space is left on the device where
>
> you have your LMS cache (see Settings/Information), and/or the system's
>
> temporary folder ("ECHO %Temp%" in a command window)?
On the SSD, on which LMS and the temporary files/caches are running,
there are still about 170 GB free out of 250 GB:
C:\>echo %temp%
C:\Users\HP\AppData\Local\Temp
Verzeichnis von C:\Users\HP\AppData\Local\Temp
18.08.2021 07:35 .
18.08.2021 07:35 ..
18.08.2021 07:4153 .ses
18.08.2021 07:09 0
1d7ad939-4130-42ad-9c52-565f02bd6ea9.tmp
18.08.2021 07:34 0
8e990bec-717d-431e-860e-4256fad76d24.tmp
18.08.2021 06:16 0
921253ca-3004-4e51-b83b-7137ff81d219.tmp
18.08.2021 07:34 0
965e0943-ba2b-4db8-9e52-4d1a8fc37213.tmp
18.08.2021 07:33 0
fff56c07-7f10-487a-a451-dfee1e80558d.tmp
29.05.2021 11:44 Low
17.08.2021 18:31 MicroThemePackDir
16.08.2021 21:48 pdk-HP-8524
17.08.2021 00:3539'888 wct1950.tmp
06.08.2021 19:45 726 wct1AE7.tmp
11.08.2021 20:1539'853 wct32FB.tmp
06.08.2021 19:45 726 wct358C.tmp
13.08.2021 19:3539'887 wct652A.tmp
13.08.2021 19:3539'887 wct67CE.tmp
06.08.2021 19:45 726 wct67FA.tmp
06.08.2021 19:45 726 wct6975.tmp
11.08.2021 20:1539'853 wct6ABB.tmp
06.08.2021 19:45 726 wct7115.tmp
09.08.2021 23:2039'853 wct8E85.tmp
06.08.2021 19:45 726 wct9155.tmp
11.08.2021 20:1539'853 wctDCEC.tmp
06.08.2021 19:45 726 wctDF9D.tmp
13.08.2021 19:3539'887 wctE79A.tmp
06.08.2021 19:45 726 wctEAE7.tmp
22 Datei(en),324'822 Bytes
5 Verzeichnis(se), 180'355'096'576 Bytes frei
I added a small number of small playlists back to the playlist folder
(*.m3u). These were scanned without errors. Will check occasionally if
the error occurs because of a specific playlist or because of the
accumulation of a larger number of large playlists.
I have uploaded library.db to your dropbox.
Thank you!
Bronx
Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115
View this thread: http://forums.slimdevices.com/showthread.php?t=114928
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
d6jg wrote: > I think what Michael was inferring was that a Linux server on like for > like hardware is likely to be considerably faster than running under > Windows. A lot of us run our LMS on Linux but also have a Windows or Mac > PC to do the music file editing exposing the files on the Linux box to > the Windows / Mac PC by Samba or similar. Do you have your music files > on the PC itself or by attached USB drives etc? I can imagine that all other things being equal, a Linux server will probably run faster and perhaps more stable. But I haven't had any performance problems or stability issues so far. The music is stored on two external USB3 hard drives, each with 6TB capacity. And there are two of the same attached on my primary, current notebook that I use as backups (and the rest of my data). Bronx Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
Bronx wrote: > I have never tried Linux. I use various music editing programs, for > which so far I have not found an equivalent replacement under Linux. In > addition, I always use the previous notebook for the server, which I > have replaced by a current more powerful, so Windows is on it from the > beginning. > Thanks for the tip about browsing the filesystem. > I have logged the memory usage during the rescan under 8.2.1. The result > is roughly the same as in 7.9.3. Start at about 48%, up to 58%, then to > about 68% at the end and then it stops. The fact that the usage is 3-5 % > points higher may only have to do with the running performance monitor > or other background processes. The memory usage of 68% does not go down > after the abort. Scanner.log is identical to my first mail. According to > the log, the abort occurs at the completion of the 4th full-text index > (playlists). > Bronx > 35509 I just moved all my playlists out of the playlist-folder and then the rescan completed without any error. So there must have changed something concerning the handling of playlists? Some of them have many thousand titles. Bronx Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
mherger wrote: > > 8 hours / one night whitout music. > > Did you ever consider running your server under Linux? Would be > interesting to see whether there was a considerable difference. > > BTW: you should be able to play music by using the "browse filesystem" > menu (NOT Browse Musicfolder!). And currently queued up tracks should > continue to play during a full scan. I have never tried Linux. I use various music editing programs, for which so far I have not found an equivalent replacement under Linux. In addition, I always use the previous notebook for the server, which I have replaced by a current more powerful, so Windows is on it from the beginning. Thanks for the tip about browsing the filesystem. I have logged the memory usage during the rescan under 8.2.1. The result is roughly the same as in 7.9.3. Start at about 48%, up to 58%, then to about 68% at the end and then it stops. The fact that the usage is 3-5 % points higher may only have to do with the running performance monitor or other background processes. The memory usage of 68% does not go down after the abort. Scanner.log is identical to my first mail. According to the log, the abort occurs at the completion of the 4th full-text index (playlists). Bronx 35509 +---+ |Filename: scanner.log.zip | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=35509| +---+ Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
mherger wrote: > > I have logged the memory usage searches for new and changed music > titles > > under 7.9.3. Of the 8 GB of memory, 44% is used at the start, rising > to > > 55% when scanning the last tracks, then dropping again and peaking at > > around 65% when creating the full-text indexes at the last (7th) > index, > > then dropping again to around 50% during database optimization. The > swap > > file moves from 700 MB to around 1,000 MB in the same period, then > goes > > back to 700 MB. Nothing I would consider critical, unless the indexes > > had much higher memory requirements under 8.2.0. > > I would not expect 8.2 to use considerably more memory. So this should > be good. > > > BTW: The live music archive is not an online music service, is it? > > I think it has become part of archive.org. > > > Maybe I'll try the same thing with 8.2.0, only it's a lot of time > > consuming. > Would be great! How long does a full scan take? 8 hours / one night whitout music. Bronx Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
mherger wrote: > > Size of library.db is 3,56 GB. > > Content: 1.077.925 titles (all MP3). > > Ok, that's not the Pi0 choking on a 50k tracks collection :-D. > > > No online music services (except internet radio). > > Hardware: Intel i5 with 8.00 GB RAM (maybe thatâs too small now for > the > > additional indexesâ¦, but i get no low memory warning) > > Could you please closely watch memory usage while running a scan in 7.9. > > Does it get close to maxing out? > > I don't see what change in LMS8 might have increased memory consumption > > considerably - except if you were to import large online music > collections. So I'm wondering whether your collection size is at a > tipping point where even a small change in memory consumption can cause > > the failure. But then... 8GB should be fine IMHO. You didn't turn off > swapping, did you? Swapping is active. I have logged the memory usage searches for new and changed music titles under 7.9.3. Of the 8 GB of memory, 44% is used at the start, rising to 55% when scanning the last tracks, then dropping again and peaking at around 65% when creating the full-text indexes at the last (7th) index, then dropping again to around 50% during database optimization. The swap file moves from 700 MB to around 1,000 MB in the same period, then goes back to 700 MB. Nothing I would consider critical, unless the indexes had much higher memory requirements under 8.2.0. BTW: The live music archive is not an online music service, is it? Maybe I'll try the same thing with 8.2.0, only it's a lot of time consuming. Thanks. Bronx Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
Size of library.db is 3,56 GB. Content: 1.077.925 titles (all MP3). No online music services (except internet radio). Hardware: Intel i5 with 8.00 GB RAM (maybe thats too small now for the additional indexes , but i get no low memory warning) Windows 10 - DE - cp1252 Plattformarchitektur: 8664 Perl-Version: 5.14.1 - MSWin32-x86-multi-thread Audio::Scan: 0.95 IO::Socket::SSL: 2.024 Datenbankversion: DBD::SQLite 1.58 (sqlite 3.22.0) Thank you! Bronx mherger wrote: > > The scanner does not seem to work properly for me for the last > processes > > for new and changed music and causes an abort when creating the 4th > > index. This both when the memory is set to "Maximum" and "Normal". I > had > > What hardware are you running LMS on? How large is your library? Are you > > using any online music service? Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
Dear all The scanner does not seem to work properly for me for the last processes for new and changed music and causes an abort when creating the 4th index. This both when the memory is set to "Maximum" and "Normal". I had the problem some years ago that for the database optimization with "Maximum" the provided memory was not sufficient (with Normal it worked). The reason was my large database. Michael had made an adjustment at that time and the optimization worked again. Now (tested with 8.2.0 and .1) it stops before (when creating the index). I have attached two scanner.log files. One at memory "maximum", the other one at "normal" . I am back to LMS 7.9.3 and scanning works again. I know it is an edge case for me because of the large collection, but maybe more are affected. Best regards Bronx +---+ |Filename: scanner.log NORM.zip | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=35494| +---+ Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
Thank you mherger - I was brave and made an update for the first time in 2 years. Indeed, trackstat and the dynamic playlists run fine, if "unsupported plugins" is checked. Thanks very much! Bronx mherger wrote: > > 1'000 thanks to mherger. Can somebody please tell me if it will work > > with erland's trackstat plugin "out of the box", if not, what should > I > > do to make sure it will work with my old trackstat-ratings and a very > > huge database. > > It should just work. There's a setting on the plugins page to allow > "unsupported" plugins. TrackStat is one of them. "Unsupported" here > means "orphaned" or "abandoned by its autor". Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Logitech Media Server 8.2.0 released
Dear all 1'000 thanks to mherger. Can somebody please tell me if it will work with erland's trackstat plugin "out of the box", if not, what should I do to make sure it will work with my old trackstat-ratings and a very huge database. Many thanx! Bronx My system: Version: 7.9.3 - 1596893334 @ Sun Aug 9 04:07:48 WEDT 2020 Hostname: EliteBook IP-Adresse des Servers: 192.xx Betriebssystem: Windows 10 - DE - cp1252 Plattformarchitektur: 8664 Perl-Version: 5.14.1 - MSWin32-x86-multi-thread Audio::Scan: 0.95 IO::Socket::SSL: 2.024 Datenbankversion: DBD::SQLite 1.58 (sqlite 3.22.0) Musiksammlung Gesamtanzahl Stilrichtungen: 287 Gesamtanzahl Interpreten: 48265 Gesamtanzahl Alben: 88005 Gesamtanzahl Titel: 1075878 Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=114928 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Database optimization fails
DJanGo wrote: > Is this really a big missing point? > > eg someone has 2 different apps that handle ratings. If these ratings > arent added to the Tag of the track, you soon end up with two different > ratings for a single track. > LMS does handle ratings in the track - so its just a matter of how to > export ratings from some app to the track itself? Frankly, I do not need a function to export or import ratings. I'm confident I can do this with a SQLITE browser and lots of manual labor when needed. But I don't need ratings anywhere else than on LMS. I can export playlists to mobile players based on ratings anytime. I also do not need any user-specific ratings. It's my collection with my music. Accordingly, my collection also contains my own ratings and additional information. Apart from the fact that I do not want to make the music available to third parties (outside of my family) and off course I am not allowed to do so. For family use, I could create separate databases for my family which they can edit as they wish.. What I'd simply like to do is to be able to manage ratings without a plugin, make appropriate queries and views, without having to rely on an external extension that is badly maintained and may soon no longer be updated at all. I also do not want to worry about the fact that the ratings and other Trackstat information must be saved separately, because of tables outside of lms. That's all Cheers Daniel Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=109093 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Database optimization fails
Roland0 wrote: > Ratings (and play counts) are native to LMS, so if that's all you need > (and file paths haven't changed), there's no need to import - the > existing persist.db contains these, and they are not overwritten by a > re-scan. TrackStat synchronizes it's own data with LMS' on startup. > However, if file paths haven't changed, why do you have to import in the > first place? The TrackStat data in the database should be still valid. > > > I'd use sed for this type of search/replace. Since you seem to use > Windows, see 'here' > (https://blogs.msdn.microsoft.com/zainnab/2007/07/08/grep-and-sed-with-powershell/) Hi Roland0 Thank you for this information. I didnt know about that, yet Im not sure. According to Wiki, Tracks_persistent - is the table where Squeezebox Server/Logitech Media Server stores its rating information. When changing a rating in TrackStat it will always also write the information to this table, but the tracks_persistent table will generally be overwritten during rescans. So there is some dependency from the plugin. In my experience, I had alwaays to restore the trackstat-infos after changing the harddisks, but maybe I just missed that the ratings were still there. Daniel Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=109093 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Database optimization fails
mherger wrote: > May I ask how you use the TrackStat plugin? Which of its features are > the most important? And where do the performance issues kick in? Hi Michael I periodically receive links with new albums from a provider that serves several German/Swiss/Austrian download platforms with music, for which I am invited to write reviews online. I do not care about single titles or singles or only when the album is available. I do it for a small fee per review, but it's not my main job ;-). And I'm compensated with the music ;-). I download all new albums 2-3x a month, correct the tags according to my needs (4 categories Jazz, Rock, Pop, Soul, R & B), execute Replaygain. Then I listen through the recently added, unrated albums. For this I use the predefined Trackstat queries. I rate those albums that do not interest me in one move with *, the others are listened to more closely and their titles are rated. Incidentally, over 50% of my collection is rated *, but I cannot persuade myself to delete those albums. Since LMS runs on a fast SDD and since LMS 7.9 the corresponding Trackstat queries are OK. It was much worse with 7.5.6. So the performance problems are not my main problem anymore. For my private listening I use library views. These have been a big help since 7.9. But for example, until now I have not been able to create a library view for unrated albums or titles via a advanced search query (there is missing a corresponding variable in the input mask, perhaps this is not possible). Trackstat may not be well integrated into LMS as a plugin in this respect. However, it's easy to compile titles with minimal ratings for a given time period or genre via a library view. These work well: 2018_3 + (163 tracks) (Example: All tracks rated at least *** from albums from 2018) 3+ (198,663 tracks) (Example: All tracks with at least ***) 4+ (23,034 tracks) (Example: All tracks rated at least ) 5 (3,139 tracks) (Example: All titles rated *) 5_Classical (102 titles) 5_Jazz (119 tracks) Added2018 (46,382 tracks) AllClassical (43,412 tracks) AllJazz (129,925 tracks) BestOf00s (6,329 tracks) BestOf1968 (180 titles) BestOf2010 + (4,175 titles) BestOf2016 + (111 tracks) BestOf50s (143 tracks) BestOf60s (1,001 tracks) BestOf70s (2,930 tracks) BestOf80s (3,731 tracks) BestOf90s (4,682 titles) BestOfAll (23,034 tracks) BestOfAll320kb / s (12,244 tracks) BestOfAll_ohne_Klassik (22,445 titles) BestOfClassical (758 titles) BestOfJazz (2,269 tracks) BestOfVor1950 (7 tracks) before1950 (8,156 tracks) Main problem: I've had to replace the external hard drives several times, be it because of full disk or defects. I also have 3 backup generations. It is extremely cumbersome to restore reviews with Trackstat Restore. The import always takes several days. There is also no feedback about the restore status. The file paths must match exactly (or I have to manually edit the backup file, which is not trivial because oft he file size of about 300 MB). If Trackstat was integrated with LMS, I could sleep better. Still, LMS is by far the best thing I've come across for my purposes. And I even asked radio studios about their professional systems. These exceed my financial possibilities. Best regards Daniel Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=109093 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Database optimization fails
mherger wrote: > I'd even recommend to delete it and artwork.db (NOT persist.db) - if you > can afford the time to re-build it. Depending on how long you've been > running LMS, and how you did upgrade to 7.9 it might miss some > configuration parameters I implemented in 7.9 which would only be > applied when the file is re-built from scratch. Thank you Michael. Did wipe these files this morning after stopping lms, restarted lms, scanning started and will report results back tomorrow after work. Daniel Bronx's Profile: http://forums.slimdevices.com/member.php?userid=33115 View this thread: http://forums.slimdevices.com/showthread.php?t=109093 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
