Dan_86 9 Posted 1 hour ago Posted 1 hour ago (edited) 9 hours ago, liyafeifei said: I think the difference may be the SQLite version. For Docker and/or Debian packages, it reports SQLite 3.51.3, while the Windows build and the 4.11.0.4 beta use SQLite 3.54.3. 2026-10-02 15:28:23.740 Info SqliteUserRepository: Sqlite version: 3.51.3 In addition, starting with 3.51.2, SQLite introduced changes to the EXISTS-to-JOIN optimization that are directly related to the search query shape and query planner. This could potentially cause negative performance depending on the actual library data. This makes sense, I think this is only affecting extremely large libraries as well. 4.11.0.4 beta is fine searching with every app. My question to Luke is why aren't you and your team just promoting full beta's to stable? instead you guys cherry pick parts of beta to create a build that's not even be tested and tag it "stable". curious as to why you guys do that when the majority test a beta release. Edited 1 hour ago by Dan_86
Luke 43206 Posted 48 minutes ago Posted 48 minutes ago 53 minutes ago, Dan_86 said: This makes sense, I think this is only affecting extremely large libraries as well. 4.11.0.4 beta is fine searching with every app. My question to Luke is why aren't you and your team just promoting full beta's to stable? instead you guys cherry pick parts of beta to create a build that's not even be tested and tag it "stable". curious as to why you guys do that when the majority test a beta release. As soon as the first 4.10 release goes out, 4.11 starts moving forward with new development. We can't just merge all of that to stable as you'll get all of the instability that comes with that. We will look into whether there is a discrepancy with the Sqlite versions, and if there is, it will be corrected in the next 4.10 maintenance release. Thanks. 1
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now