Home of the Squeezebox™ & Transporter® network music players.
Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 38
  1. #21
    Senior Member
    Join Date
    Sep 2005
    Posts
    2,845
    Quote Originally Posted by mherger View Post
    The new binaries currently are only available for macOS (Perl 5.18,
    64-bit only), Windows, Linux x86_64/5.10 and armhf/5.20.

    --

    Michael
    Hi, are you sure about that?

    Code:
    ls /usr/share/squeezeboxserver/CPAN/arch/
    5.12  5.14  5.16  5.18  5.20  5.22  5.24  5.26
    there is no 5.10 in the Linux x86_64 debian.

  2. #22
    Senior Member
    Join Date
    Jan 2006
    Location
    South Coast, NSW, Australia
    Posts
    1,255
    Quote Originally Posted by mherger View Post
    > Ran Clear & Rescan on Win 10 twice -
    >
    > Logitech Media Server Version: 7.9.2 - 1530185314 @ Thu Jun 28 14:09:09
    > Total Time: 01:14:52 (Saturday, September 15, 2018 / 10:12 AM)
    >
    > Logitech Media Server Version: 7.9.2 - 1536946607 @ Fri Sep 14 20:08:11
    > Total Time: 01:14:02 (Saturday, September 15, 2018 / 1:08 PM)


    Wow... not much of an improvement :-)

    > I suspect disk i/o on the music library is the limiting factor, but
    > great to have scratched the "why isn't sqlite upgraded" itch.
    > Drive C on this box is a Samsung EVO 850 M2 SSD, 250GB with 170GB free,
    > Music is a Toshiba MD04ACA400 7,200rpm 4TB.


    Internal, not USB? Is this a dedicated system? And is the VB system you
    mentioned using the same library? Would be interesting to see how they
    compare.

    --

    Michael
    Internal drive.
    Win 10 box is a workstation and "master" for music and video processing, i3-8100 CPU @ 3.60GHz, 8GB, quad core.
    For this exercise it was a dedicated system.
    Music library is distributed via FreeFileSync to Vortexbox servers.
    A camel is a racehorse designed by a committee.

    Seen sprayed on the outside wall of the local library -
    Three things I hate in life :
    1. Vandalism
    2. Irony
    3. Lists

  3. #23
    Senior Member
    Join Date
    Jan 2006
    Location
    South Coast, NSW, Australia
    Posts
    1,255
    Quote Originally Posted by mherger View Post
    > Just installed RedHat (RPM) Installer Package Logitech Media Server
    > Version: 7.9.2 - 1536946607 @ Fri Sep 14 on my Vortexbox but it is still
    > Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1).


    What's the Perl version string (incl. processor architecture)?

    --

    Michael
    Logitech Media Server Version: 7.9.2 - 1536946607 @ Fri Sep 14 20:14:29 CEST 2018
    Hostname: coolvbox
    IP: 192.168.2.26
    HTTP Port: 9000
    OS: Red Hat - EN - utf8
    Platform: x86_64-linux
    Perl Version: 5.24.3 - x86_64-linux-thread-multi
    Audio::Scan: 0.95
    IO::Socket::SSL: 2.038
    Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1)
    Total Players Recognized: 3
    A camel is a racehorse designed by a committee.

    Seen sprayed on the outside wall of the local library -
    Three things I hate in life :
    1. Vandalism
    2. Irony
    3. Lists

  4. #24
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,295

    LMS 7.9.2: updated SQLite module v1.58

    > ls /usr/share/squeezeboxserver/CPAN/arch/
    > 5.12 5.14 5.16 5.18 5.20 5.22 5.24 5.26
    >
    > there is no 5.10 in the Linux x86_64 debian.


    Haha... one of the few versions I built isn't even included in the
    packages any more (except in the tarballs)... because nobody uses it -
    except myself :-D. You're right, I stripped 5.8 and 5.10 out of those
    installers a while back. Maybe 5.12 could be removed, too.

    --

    Michael

  5. #25
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,295

    LMS 7.9.2: updated SQLite module v1.58

    > Perl Version: 5.24.3 - x86_64-linux-thread-multi

    Should be available now. Please update and report back. Thanks!

    --

    Michael

  6. #26
    Senior Member
    Join Date
    Aug 2012
    Location
    Austria
    Posts
    913
    Here are the results from the benchmark posted in this thread:
    Name:  lms-dbd.png
Views: 166
Size:  35.6 KB
    The first graph is without the trackstat queries, the second with them.
    Each pair of bars (red for old SQLite / blue for new SQLite) represents a single run of the benchmark.
    At least on this system (RPi3), the speedup is significant and noticeable in interactive use of DB-bound functionality (e.g. show all tracks by an artist, TrackStats top rated genres etc.)

  7. #27
    Senior Member
    Join Date
    Jan 2006
    Location
    South Coast, NSW, Australia
    Posts
    1,255
    Quote Originally Posted by mherger View Post
    > Perl Version: 5.24.3 - x86_64-linux-thread-multi

    Should be available now. Please update and report back. Thanks!

    --

    Michael
    Ran Clear & rescan
    Logitech Media Server Version: 7.9.2 - 1536072399 @ Tue Sep 4 17:14:43 CEST 2018
    Hostname: coolvbox
    IP: 192.168.2.26
    HTTP Port: 9000
    OS: Red Hat - EN - utf8
    Platform: x86_64-linux
    Perl Version: 5.24.3 - x86_64-linux-thread-multi
    Audio::Scan: 0.95
    IO::Socket::SSL: 2.038
    Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1)
    Total Players Recognized: 5

    Media Scan Details
    Discovering files/directories: /storage/music/flac (173513 of 173513) Complete 00:00:18
    Scanning new music files: /storage/music/flac (157896 of 157896) Complete 00:34:50
    Discovering files/directories: /storage/music/mp3 (9909 of 9909) Complete 00:00:01
    Scanning new music files: /storage/music/mp3 (8804 of 8804) Complete 00:04:00
    Discovering files/directories: /storage/music/Audio Books (587 of 587) Complete 00:00:00
    Scanning new music files: /storage/music/Audio Books (579 of 579) Complete 00:00:08
    Discovering playlists: /storage/music/playlist_linux (38 of 38) Complete 00:00:01
    Scanning new playlists: /storage/music/playlist_linux (36 of 36) Complete 00:00:03
    MusicIP Import (167279 of 167279) Complete 00:09:21
    Album cover lookup (11 of 11) Complete 00:00:04
    Artist picture lookup (3731 of 3731) Complete 00:02:52
    Building full text index (7 of 7) Complete 00:01:21
    Pre-caching Artwork (12641 of 12641) Complete 00:05:53
    Database Optimize (2 of 2) Complete 00:00:59
    The server has finished scanning your media library.
    Total Time: 00:59:51 (Saturday, September 15, 2018 / 9:23 AM)

    Logitech Media Server Version: 7.9.2 - 1537028423 @ Sat Sep 15 18:43:01 CEST 2018
    Hostname: coolvbox
    Server IP Address: 192.168.2.26
    Server HTTP Port Number: 9000
    Operating system: Red Hat - EN - utf8
    Platform Architecture: x86_64-linux
    Perl Version: 5.24.3 - x86_64-linux-thread-multi
    Audio::Scan: 0.95
    IO::Socket::SSL: 2.038
    Database Version: DBD::SQLite 1.58 (sqlite 3.22.0)
    Total Players Recognized: 6

    Media Scan Details
    Discovering files/directories: /storage/music/flac (173513 of 173513) Complete 00:00:16
    Scanning new music files: /storage/music/flac (157896 of 157896) Complete 00:31:37
    Discovering files/directories: /storage/music/mp3 (9909 of 9909) Complete 00:00:00
    Scanning new music files: /storage/music/mp3 (8804 of 8804) Complete 00:03:18
    Discovering files/directories: /storage/music/Audio Books (587 of 587) Complete 00:00:00
    Scanning new music files: /storage/music/Audio Books (579 of 579) Complete 00:00:08
    Discovering playlists: /storage/music/playlist_linux (38 of 38) Complete 00:00:00
    Scanning new playlists: /storage/music/playlist_linux (36 of 36) Complete 00:00:02
    MusicIP Import (167279 of 167279) Complete 00:08:54
    Album cover lookup (11 of 11) Complete 00:00:00
    Artist picture lookup (3731 of 3731) Complete 00:02:52
    Building full text index (7 of 7) Complete 00:01:18
    Pre-caching Artwork (12641 of 12641) Complete 00:05:04
    Database Optimize (2 of 2) Complete 00:01:00
    The server has finished scanning your media library.
    Total Time: 00:54:29 (Sunday, September 16, 2018 / 7:54 AM)


    Vortexbox 2.5 on Fedora 25, Pentium G3420 dual core @ 3.20GHz 6GB ram.
    /dev/sda (Corsair Force 3 SSD)
    /dev/sdb (ST4000DM000-1F2168)
    /dev/sdc (ST4000DM000-1F2168)
    /dev/mapper/StorageVM-lv_storage ext4 7.15TiB

    CoolVBox is my "production" server and will run all day so I will report back if there are any problems. But limited testing shows searches, new music listing and other listings are all still very quick especially when compared to the Win 10 box.
    Last edited by Wirrunna; 2018-09-15 at 15:24. Reason: Added RAM
    A camel is a racehorse designed by a committee.

    Seen sprayed on the outside wall of the local library -
    Three things I hate in life :
    1. Vandalism
    2. Irony
    3. Lists

  8. #28
    Senior Member
    Join Date
    Sep 2005
    Posts
    2,845
    Thats very impressive ;-)

    a scan from scratch on a overpowered i7 debian system once was 00:43:16 and now its only 00:36:00 !
    running both scans two times to make sure its not anything else than the changed dbi.

  9. #29
    Senior Member ralphy's Avatar
    Join Date
    Jan 2006
    Location
    Canada
    Posts
    2,202
    Clear and Rescan is a bit faster on my aging quad core 8GB system using High memory config.
    LMS cache folder on SSD, music files on SATA HD.
    Best of 2 for each DBD::SQLite version.

    Code:
    Logitech Media Server Version: 7.9.2 - r20510.9fbe679 @ 1536957153
    Operating system: Debian - EN - utf8
    Platform Architecture: i686-linux
    Perl Version: 5.14.2 - i386-linux-gnu-thread-multi-64int
    Audio::Scan: 1.01
    IO::Socket::SSL: 1.76
    Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1)
    Total Players Recognized: 8
     
    Library Statistics
    Total Tracks: 29,217
    Total Albums: 2,450
    Total Artists: 818
    Total Genres: 104
    Total Playing Time: 2119:35:58
     
    Media Scan Details
    Discovering files/directories: /export/music0   (31868 of 31868)   Complete  00:00:08
    Scanning new music files: /export/music0   (29005 of 29005)   Complete  00:02:24
    Discovering playlists: /home/sc/playlists   (14 of 14)   Complete  00:00:00
    Scanning new playlists: /home/sc/playlists   (12 of 12)   Complete  00:00:02
    Pre-caching Artwork   (1260 of 1260)   Complete  00:02:37
    Database Optimize   (2 of 2)   Complete  00:00:04
    
    The server has finished scanning your media library.
    Total Time: 00:05:15 (Sunday, September 16, 2018 / 7:46 AM)
    
    Database Version: DBD::SQLite 1.58 (sqlite 3.22.0)
     
    Media Scan Details
    
    Discovering files/directories: /export/music0   (31868 of 31868)   Complete  00:00:07
    Scanning new music files: /export/music0   (29005 of 29005)   Complete  00:01:36
    Discovering playlists: /home/sc/playlists   (14 of 14)   Complete  00:00:00
    Scanning new playlists: /home/sc/playlists   (12 of 12)   Complete  00:00:02
    Pre-caching Artwork   (1260 of 1260)   Complete  00:02:42
    Database Optimize   (2 of 2)   Complete  00:00:03
    
    The server has finished scanning your media library.
    Total Time: 00:04:30 (Sunday, September 16, 2018 / 8:04 AM)
    Ralphy

    1-Touch, 5-Classics, 3-Booms, 1-UE Radio
    Squeezebox client builds donations always appreciated.

  10. #30
    Senior Member bakker_be's Avatar
    Join Date
    May 2009
    Location
    Kwaadmechelen, Belgium
    Posts
    796
    On a repurposed Lenovo T540, i5-4300M CPU, 16 GB RAM, USB3 direct attached storage, Performance settings in LMS set to "Maximum" I get the following results.
    Old Scan:
    Code:
    Logitech Media Server Version: 7.9.2 - 1536840407 @ Thu Sep 13 14:15:50 CEST 2018
    Hostname: ubuntu_t540
    Server IP Address: 192.168.1.101
    Server HTTP Port Number: 9000
    Operating system: Debian - EN - utf8
    Platform Architecture: x86_64-linux
    Perl Version: 5.26.1 - x86_64-linux-gnu-thread-multi
    Audio::Scan: 0.95
    IO::Socket::SSL: 2.056
    Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1)
    Total Players Recognized: 4
     
    Library Statistics
    Total Tracks: 116,434
    Total Albums: 6,891
    Total Artists: 13,975
    Total Genres: 84
    Total Playing Time: 13321:40:41
     
    Media Scan Details
    Discovering files/directories: /mnt/music   (125809 of 125809)   Complete  00:01:19
     
    Scanning new music files: /mnt/music   (116438 of 116438)   Complete  00:43:11
     
    Discovering playlists: /media/playlists   (1 of 1)   Complete  00:00:00
     
    Building full text index   (7 of 7)   Complete  00:00:36
     
    Pre-caching Artwork   (6104 of 6104)   Complete  00:03:11
     
    Database Optimize   (2 of 2)   Complete  00:00:18
     
    The server has finished scanning your media library.
    Total Time: 00:48:35 (Sunday, September 2, 2018 / 7:47 PM)
    New Scan:
    Code:
    Logitech Media Server Version: 7.9.2 - 1537028423 @ Sat Sep 15 18:45:00 CEST 2018
    Hostname: ubuntu_t540
    Server IP Address: 192.168.1.101
    Server HTTP Port Number: 9000
    Operating system: Debian - EN - utf8
    Platform Architecture: x86_64-linux
    Perl Version: 5.26.1 - x86_64-linux-gnu-thread-multi
    Audio::Scan: 0.95
    IO::Socket::SSL: 2.056
    Database Version: DBD::SQLite 1.58 (sqlite 3.22.0)
    Total Players Recognized: 4
     
    Media Scan Details
    Discovering files/directories: /mnt/music   (125820 of 125820)   Complete  00:00:15
     
    Scanning new music files: /mnt/music   (116447 of 116447)   Complete  00:40:25
     
    Discovering playlists: /media/playlists   (1 of 1)   Complete  00:00:00
     
    Building full text index   (7 of 7)   Complete  00:00:28
     
    Pre-caching Artwork   (6119 of 6119)   Complete  00:03:30
     
    Database Optimize   (2 of 2)   Complete  00:00:17
     
    The server has finished scanning your media library.
    Total Time: 00:44:55 (Sunday, September 16, 2018 / 2:00 PM)
    Main System: Touch; Marantz SR-5004 + TMA Premium 905 + TMA Premium 901 + Teufel Ultima 20 Mk 2 + BK Monolith+ FF + Lenovo T460 + Kodi + Pioneer PDP-LX5090H
    Workshop: iPad 32GB Wifi + Squeezepad (local playback activated)
    Wherever needed: Acer Iconia Tab A700 + Squeezeplayer
    Kitchen: iPhone 5s + iPeng (local playback activated) + NAD 312 + Teufel Ultima 20 Mk 2
    Headphone (cozy corner): Lenovo T550 + Squeezelite-X + Cyrus Soundkey + Topping A30 + Focal Elear
    Car: TBC ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •