Home of the Squeezebox™ & Transporter® network music players.
Page 4 of 25 FirstFirst ... 2345614 ... LastLast
Results 31 to 40 of 241
  1. #31
    Senior Member get.amped's Avatar
    Join Date
    Feb 2007
    Location
    Upstate NY
    Posts
    788
    Quote Originally Posted by mherger View Post
    > AND ge.namesearch IN ('ALTERNATIVE ROCK','ART ROCK','BLUES
    > ROCK','DEAD','ELECTRONICA','FOLK JAZZ','FUNK','FUNK R B','FUNK
    > SOUL','FUSION','GRUNGE','HENDRIX','INDIE','JAZZ FOLK','JAZZ FUNK','JAZZ
    > FUSION','JAZZ ROCK','LATIN ROCK','NEW WAVE','PROGRESSIVE
    > METAL','PROGRESSIVE ROCK','PUNK ROCK','R B','R B FUNK','R B
    > SOUL','ROCK','SOUL','SOUL FUNK','SOUL R B','TRIP HOP')


    > AND ge.id IN (SELECT x.id from genres x where x.namesearch IN
    > ('ALTERNATIVE ROCK','ART ROCK','BLUES ROCK','DEAD','ELECTRONICA','FOLK
    > JAZZ','FUNK','FUNK R B','FUNK
    > SOUL','FUSION','GRUNGE','HENDRIX','INDIE','JAZZ FOLK','JAZZ FUNK','JAZZ
    > FUSION','JAZZ ROCK','LATIN ROCK','NEW WAVE','PROGRESSIVE
    > METAL','PROGRESSIVE ROCK','PUNK ROCK','R B','R B FUNK','R B
    > SOUL','ROCK','SOUL','SOUL FUNK','SOUL R B','TRIP HOP'))


    Did you time the duration these two need? In my limited testing with a
    much smaller collection the second version seemed to be a tiny little
    bit faster.

    --

    Michael
    First one executes in 277 ms.

    Second one in 225 ms.

    This is running against a copy of a slightly older version of my library.db

    select count (id) from tracks

    returns 311,530 rows.
    Home: Win7Pro(x64)[3.3Ghz i5, 8GB RAM, 120GB SSD system, 15TB storage], LMS 7.9.0 -> Logitech Squeezebox Classic V.3 -> Cambridge Audio DacMagic -> NAD C160 -> 2 x NAD C272 -> Quad 22L2
    Portable: FreeNAS 9.3 [HP Microserver Gen8, 10GB RAM, 16GB flash boot, 120GB SSD for LMS 7.9.0 in FreeBSD jail, 5 x 4TB WD Red HD ZFS RAIDZ1] -> Logitech Squeezebox Classic V.3 -> Cambridge Audio DacMagic: XLR out -> Soundmaster Diamond 12-2 mixing board -> P.A.

  2. #32
    Senior Member get.amped's Avatar
    Join Date
    Feb 2007
    Location
    Upstate NY
    Posts
    788
    The multi-library demo is quite nice. I may actually use the "FLAC files only" quite a bit.
    Home: Win7Pro(x64)[3.3Ghz i5, 8GB RAM, 120GB SSD system, 15TB storage], LMS 7.9.0 -> Logitech Squeezebox Classic V.3 -> Cambridge Audio DacMagic -> NAD C160 -> 2 x NAD C272 -> Quad 22L2
    Portable: FreeNAS 9.3 [HP Microserver Gen8, 10GB RAM, 16GB flash boot, 120GB SSD for LMS 7.9.0 in FreeBSD jail, 5 x 4TB WD Red HD ZFS RAIDZ1] -> Logitech Squeezebox Classic V.3 -> Cambridge Audio DacMagic: XLR out -> Soundmaster Diamond 12-2 mixing board -> P.A.

  3. #33
    Senior Member Mnyb's Avatar
    Join Date
    Feb 2006
    Location
    Västerås Sweden
    Posts
    16,525
    Quote Originally Posted by get.amped View Post
    The multi-library demo is quite nice. I may actually use the "FLAC files only" quite a bit.
    Where did you find this ?

    This demo plugin seems a bit elusive i cant find any of its settings anywhere nor the plugin itself ? in the plauging list
    Last edited by Mnyb; 2014-06-18 at 17:31.
    --------------------------------------------------------------------
    Main hifi: Rasbery PI digi+ MeridianG68J MeridianHD621 MeridianG98DH 2 x MeridianDSP5200 MeridianDSP5200HC 2 xMeridianDSP3100 +Rel Stadium 3 sub.
    Bedroom/Office: Boom
    Loggia: Raspi hifiberry dac + Adams
    Bathroom : Radio (with battery)
    iPad with iPengHD & SqueezePad
    (spares Touch, SB3, reciever ,controller )
    server Intel NUC Esxi VM Linux mint 18 LMS 7.9.2

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

  4. #34
    Senior Member Mnyb's Avatar
    Join Date
    Feb 2006
    Location
    Västerås Sweden
    Posts
    16,525
    Quote Originally Posted by Mnyb View Post
    Where did you find this ?

    This demo plugin seems a bit elusive i cant find any of its settings anywhere nor the plugin itself ? in the plauging list
    find that browse mode but not where to setup your own modes where did this flac only being configured
    --------------------------------------------------------------------
    Main hifi: Rasbery PI digi+ MeridianG68J MeridianHD621 MeridianG98DH 2 x MeridianDSP5200 MeridianDSP5200HC 2 xMeridianDSP3100 +Rel Stadium 3 sub.
    Bedroom/Office: Boom
    Loggia: Raspi hifiberry dac + Adams
    Bathroom : Radio (with battery)
    iPad with iPengHD & SqueezePad
    (spares Touch, SB3, reciever ,controller )
    server Intel NUC Esxi VM Linux mint 18 LMS 7.9.2

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

  5. #35
    Senior Member get.amped's Avatar
    Join Date
    Feb 2007
    Location
    Upstate NY
    Posts
    788
    Quote Originally Posted by Mnyb View Post
    find that browse mode but not where to setup your own modes where did this flac only being configured
    First make sure "Switch library view is check in the per player settings:

    Name:  playerbrowsesettings.jpg
Views: 432
Size:  46.0 KB

    Then go to "Switch library view" in My Music:

    Name:  switchlibraryview.jpg
Views: 432
Size:  22.5 KB

    Then select "FLAC files only"

    Name:  FLACfilesonly.jpg
Views: 433
Size:  18.1 KB

    When you go back to "Home" you will see the change in the status line:

    Name:  librarystatus.jpg
Views: 433
Size:  13.6 KB
    Home: Win7Pro(x64)[3.3Ghz i5, 8GB RAM, 120GB SSD system, 15TB storage], LMS 7.9.0 -> Logitech Squeezebox Classic V.3 -> Cambridge Audio DacMagic -> NAD C160 -> 2 x NAD C272 -> Quad 22L2
    Portable: FreeNAS 9.3 [HP Microserver Gen8, 10GB RAM, 16GB flash boot, 120GB SSD for LMS 7.9.0 in FreeBSD jail, 5 x 4TB WD Red HD ZFS RAIDZ1] -> Logitech Squeezebox Classic V.3 -> Cambridge Audio DacMagic: XLR out -> Soundmaster Diamond 12-2 mixing board -> P.A.

  6. #36
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,324

    Multi Library support in LMS 7.9

    >> This demo plugin seems a bit elusive i cant find any of its settings
    >> anywhere nor the plugin itself ? in the plauging list

    >
    > find that browse mode but not where to setup your own modes where did
    > this flac only being configured


    It's a DEMO. There's nothing to configure. I guess I'll have to remove it...

    --

    Michael

  7. #37
    Senior Member Mnyb's Avatar
    Join Date
    Feb 2006
    Location
    Västerås Sweden
    Posts
    16,525
    Quote Originally Posted by get.amped View Post
    First make sure "Switch library view is check in the per player settings:

    Name:  playerbrowsesettings.jpg
Views: 432
Size:  46.0 KB

    Then go to "Switch library view" in My Music:

    Name:  switchlibraryview.jpg
Views: 432
Size:  22.5 KB

    Then select "FLAC files only"

    Name:  FLACfilesonly.jpg
Views: 433
Size:  18.1 KB

    When you go back to "Home" you will see the change in the status line:

    Name:  librarystatus.jpg
Views: 433
Size:  13.6 KB
    Aha that's all I've found those ok it works as designed , don't remove it , it mostly aimed at other developers to use is it ?
    --------------------------------------------------------------------
    Main hifi: Rasbery PI digi+ MeridianG68J MeridianHD621 MeridianG98DH 2 x MeridianDSP5200 MeridianDSP5200HC 2 xMeridianDSP3100 +Rel Stadium 3 sub.
    Bedroom/Office: Boom
    Loggia: Raspi hifiberry dac + Adams
    Bathroom : Radio (with battery)
    iPad with iPengHD & SqueezePad
    (spares Touch, SB3, reciever ,controller )
    server Intel NUC Esxi VM Linux mint 18 LMS 7.9.2

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

  8. #38
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,324

    Multi Library support in LMS 7.9

    > Aha that's all I've found those ok it works as designed , don't
    > remove it , it mostly aimed at other developers to use is it ?


    Primarily for myself, to validate the changes. And as a demo for plugin
    developers to show what can be done, and how it can be done.

    I'm probably going to provide a different plugin which will make a
    little more sense. Not strictly for the end-user, as it'll will require
    you to do some SQL. But it would allow for experienced users to do
    sub-libraries, and easily share these by posting some SQL to copy/paste.

    --

    Michael

  9. #39
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,324
    I just added another library definition which I call "Lossless Preferred": it attempts to solve the issue where users have two copies of a track, once lossy (for mobile use) and once lossless. Previously this would result in duplicate albums and tracks in your library. This new library definition tries to filter out those dupes.

    Please note that this will not merge albums if some tracks of the album were lossy and others not. We can't easily compensate for the mess you create ;-).

    In order to get this virtual library you'll have to run a rescan (no wipe required).

    And for the geeks: here's the SQL I'm using. Please let me know if you see any potential for improvement.

    Code:
    				SELECT tracks.id
    				FROM tracks, albums
    				WHERE albums.id = tracks.album 
    				AND (
    					tracks.lossless 
    					OR 1 NOT IN (
    						SELECT 1
    						FROM tracks other
    						JOIN albums otheralbums ON other.album
    						WHERE other.title = tracks.title
    						AND other.lossless
    						AND other.primary_artist = tracks.primary_artist
    						AND other.tracknum = tracks.tracknum
    						AND other.year = tracks.year
    						AND otheralbums.title = albums.title
    					)
    				)
    Tracks in this library are either lossless or there's no lossless track with the same title, album title, primary artist, track number and year.
    Michael

    http://www.herger.net/slim-plugins - Spotty, MusicArtistInfo

  10. #40
    Senior Member erland's Avatar
    Join Date
    Dec 2005
    Location
    Sweden
    Posts
    11,039
    Quote Originally Posted by mherger View Post
    I'm probably going to provide a different plugin which will make a
    little more sense. Not strictly for the end-user, as it'll will require
    you to do some SQL. But it would allow for experienced users to do
    sub-libraries, and easily share these by posting some SQL to copy/paste.
    Just for information, I started to create a plugin based on my Multi Library plugin today for this, it's going to be named "Virtual Libraries".
    Just mentioning it so we can avoid name collisions if you plan to do something similar.

    Hope to have it ready for beta testing at the end of the week unless I get stuck on something.
    Erland Isaksson (My homepage)
    Developer of many plugins/applets

Posting Permissions

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