• Login
  • Register
  • Login Register
    Login
    Username/Email:
    Password:
    Or login with a social network below
  • Forum
  • Website
  • GitHub
  • Status
  • Translation
  • Features
  • Team
  • Rules
  • Help
  • Feeds
User Links
  • Login
  • Register
  • Login Register
    Login
    Username/Email:
    Password:
    Or login with a social network below

    Useful Links Forum Website GitHub Status Translation Features Team Rules Help Feeds
    Jellyfin Forum Support General Questions Any ways to optimize search speed for large libraries?

     
    • 0 Vote(s) - 0 Average

    Any ways to optimize search speed for large libraries?

    Searching my 150k+ track music library is a bit slow
    TheDreadPirate
    Offline

    Community Moderator

    Posts: 15,374
    Threads: 10
    Joined: 2023 Jun
    Reputation: 460
    Country:United States
    #4
    2024-09-18, 03:51 PM
    You could remove all tags from the database, if you don't care about them.  You'd have to install sqlite3 and open the database file after stopping the jellyfin container.  Since this is unRAID, I'm not sure if you'd be able to do this on the server.  But you could copy the library.db file to another PC and run the commands there.

    I strongly recommend backing up your install before attempting this.

    Code:
    DELETE FROM TypedBaseItems
    WHERE Tags IS NOT NULL
    Jellyfin 10.10.7 (Docker)
    Ubuntu 24.04.2 LTS w/HWE
    Intel i3 12100
    Intel Arc A380
    OS drive - SK Hynix P41 1TB
    Storage
        4x WD Red Pro 6TB CMR in RAIDZ1
    [Image: GitHub%20Sponsors-grey?logo=github]
    « Next Oldest | Next Newest »

    Users browsing this thread: 1 Guest(s)


    Messages In This Thread
    Any ways to optimize search speed for large libraries? - by Zedniac - 2024-09-18, 02:45 AM
    RE: Any ways to optimize search speed for large libraries? - by pixel24 - 2024-09-18, 10:25 AM
    RE: Any ways to optimize search speed for large libraries? - by Zedniac - 2024-09-18, 03:26 PM
    RE: Any ways to optimize search speed for large libraries? - by TheDreadPirate - 2024-09-18, 03:51 PM
    RE: Any ways to optimize search speed for large libraries? - by Zedniac - 2024-09-18, 04:08 PM
    RE: Any ways to optimize search speed for large libraries? - by TheDreadPirate - 2024-09-18, 04:12 PM
    RE: Any ways to optimize search speed for large libraries? - by Zedniac - 2024-09-18, 04:38 PM

    • View a Printable Version
    • Subscribe to this thread
    Forum Jump:

    Home · Team · Help · Contact
    © Designed by D&D - Powered by MyBB
    L


    Jellyfin

    The Free Software Media System

    Linear Mode
    Threaded Mode