Results 1 to 7 of 7

Thread: Improve Performance of Active and Smart Playlists

  1. #1
    Join Date
    Apr 2010
    Posts
    18

    Default Improve Performance of Active and Smart Playlists

    Some active and smart playlists--including built-in playlists such as "All Photo Files"--take a long time to open when they contain many files. Based on how long it takes, I'm guessing a SQL query is run each time. This makes the playlist smart or dynamic, but slow with large collections.

    Using Views instead of queries should improve performance dramatically since the result set is stored and only refreshed as needed.
    Windows 7 Pro x64; Mezzmo 2.4.5.0

  2. #2
    Join Date
    Nov 2007
    Location
    Melbourne, Australia
    Posts
    11,642

    Default

    The SQL query itself is usually very quick, it's the creation/loading of graphic thumbnails to display them on screen what takes the most time. Keeping those in memory would be costly RAM-wise, but we're constantly looking at way to optimize performance, so thank you for the suggestion!

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

  3. #3
    Join Date
    Dec 2010
    Posts
    2

    Default

    Is it possible to add a setting like "List files at the bottom-level playlist only for active playlists on connected devices" to Media Sever Settings dialog box?

  4. #4
    Join Date
    Nov 2007
    Location
    Melbourne, Australia
    Posts
    11,642

    Default

    Can you please describe in a bit more detail what that setting should do? Thanks!

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

  5. #5
    Join Date
    Dec 2010
    Posts
    2

    Default

    Quote Originally Posted by Dennis View Post
    Can you please describe in a bit more detail what that setting should do? Thanks!
    For example, I have an Active playlist "Genre->Artist->Album" and 10 albums with 100 songs in total for some artist. On top-level folder everything is great because only artist's names are displayed. But on next sub-level (Artist) I will see 10 folders followed by 100 songs and this will take a time to load all songs. Not very a lot of time but it's much faster to load albums names only.

    For all my Active playlist I know for sure that I want to see files on the bottom level only so this option will help me.

    As an alternative I'd like to have an option in Active playlist properties like "List files starting from %LEVEL% only" with opportunity to point to any level in this Active playlist.

    Thanks!

  6. #6
    Join Date
    Nov 2007
    Location
    Melbourne, Australia
    Posts
    11,642

    Default

    Ok, I understand. I'll make a note of it to implement in a future release - thanks for the suggestion!

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

  7. #7
    Join Date
    Apr 2010
    Posts
    18

    Default

    Quote Originally Posted by dwurf View Post
    Is it possible to add a setting like "List files at the bottom-level playlist only for active playlists on connected devices" to Media Sever Settings dialog box?
    dwurf, your question seems completely unrelated to the topic of this thread. Any particular reason you posted it here?
    Windows 7 Pro x64; Mezzmo 2.4.5.0

Tags for this Thread

Bookmarks

Posting Permissions

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