Home of the Squeezebox™ & Transporter® network music players.
Page 3 of 3 FirstFirst 123
Results 21 to 26 of 26
  1. #21
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,103

    Why is LMS using such an old SQLite version?

    >> Running this kind of stuff in a loop would likely only hit SQLite's
    >> buffer - which is not representative either.
    >>

    > Not sure about that. If I were to speculate: SQLite doesn't seem to do
    > any real query caching, and the buffer seems very limited, leading to a
    > weird spiking performance profile:


    If I get that chart right, then your LMS is CPU bound. Which means it's
    not waiting for I/O.

    --

    Michael

  2. #22
    Senior Member Mnyb's Avatar
    Join Date
    Feb 2006
    Location
    Vństerňs Sweden
    Posts
    16,482
    Quote Originally Posted by mherger View Post
    > I did not get the latest version for some reason using the amd64 deb...
    >
    > Perl Version: 5.22.1 - x86_64-linux-gnu-thread-multi


    The reason is explained in the announcement :-). I'll add that to the
    todo list.
    --

    Michael
    Dang so Linux mint 18 has such old Perl version
    --------------------------------------------------------------------
    Main hifi: Touch + CIA PS +MeridianG68J MeridianHD621 MeridianG98DH 2 x MeridianDSP5200 MeridianDSP5200HC 2 xMeridianDSP3100 +Rel Stadium 3 sub.
    Bedroom/Office: Boom
    Kitchen: Touch + powered Fostex PM0.4
    Misc use: Radio (with battery)
    iPad1 with iPengHD & SqueezePad
    (spares Touch, SB3, reciever ,controller )
    server HP proliant micro server N36L with ClearOS Linux

    http://people.xiph.org/~xiphmont/demo/neil-young.html

  3. #23
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,103

    Why is LMS using such an old SQLite version?

    > Dang so Linux mint 18 has such old Perl version

    Guess why I have 5.10 binaries? Because my system is still CentOS 6
    based. That's an old Perl :-).

    --

    Michael

  4. #24
    Senior Member Mnyb's Avatar
    Join Date
    Feb 2006
    Location
    Vństerňs Sweden
    Posts
    16,482
    Quote Originally Posted by mherger View Post
    > Dang so Linux mint 18 has such old Perl version

    Guess why I have 5.10 binaries? Because my system is still CentOS 6
    based. That's an old Perl :-).

    --

    Michael
    Respect what you are doing , perl seems to vary between 5.8 to 5.24 in the user base .
    Ill test when its aviable no need to rush i have modest collection of 50k tracks and a reasonably fast machine anyway.
    --------------------------------------------------------------------
    Main hifi: Touch + CIA PS +MeridianG68J MeridianHD621 MeridianG98DH 2 x MeridianDSP5200 MeridianDSP5200HC 2 xMeridianDSP3100 +Rel Stadium 3 sub.
    Bedroom/Office: Boom
    Kitchen: Touch + powered Fostex PM0.4
    Misc use: Radio (with battery)
    iPad1 with iPengHD & SqueezePad
    (spares Touch, SB3, reciever ,controller )
    server HP proliant micro server N36L with ClearOS Linux

    http://people.xiph.org/~xiphmont/demo/neil-young.html

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

    Why is LMS using such an old SQLite version?

    > Respect what you are doing , perl seems to vary between 5.8 to 5.24 in
    > the user base .


    5.26 ;-)

    > Ill test when its aviable no need to rush i have modest collection of
    > 50k tracks and a reasonably fast machine anyway.


    It should be available now. Please keep a copy of the old package: I
    don't have a system running this Perl version, therefore built using
    https://perlbrew.pl for the first time. If that is working fine, that'll
    save me some headaches in the future.

    --

    Michael

  6. #26
    Senior Member
    Join Date
    Aug 2012
    Location
    Austria
    Posts
    766
    Quote Originally Posted by mherger View Post
    >> Running this kind of stuff in a loop would likely only hit SQLite's
    >> buffer - which is not representative either.
    >>

    > Not sure about that. If I were to speculate: SQLite doesn't seem to do
    > any real query caching, and the buffer seems very limited, leading to a
    > weird spiking performance profile:


    If I get that chart right, then your LMS is CPU bound. Which means it's not waiting for I/O.
    Yes, it's 100% CPU bound. There is zero I/O during the run (the DB files are already cached in RAM), which is is one of the main reasons I prefer this benchmark to rebuild library / scan for files. The I/O of reading the files introduces a lot of overhead unrelated to the DB performance, and increases variability (e.g. due to file system caching).
    I've posted the (quite promising) results in the other thread .

Tags for this Thread

Posting Permissions

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