I don’t see the SQLite binary itself mentioned.
removed for ease of reading the commands
I don’t believe
vacuumis necessary immediately after a.dumpand load. The load already produces a fully compacted database.
Done lots of tests with and without vacuum, while plex does a vacuum on start up, doing one before starting plex back up speeds up the process considerably. But again, this is what I do and you’re welcome to ignore it
That’s not beneficial in this context.
PRAGMA optimizecan be useful for applications after they’ve been doing normal activity for a while. In this context it won’t have seen any normal queries.
again, from testing across multiple plex containers and with multiple friends testing as well - We’ve seen benefits to running it
