GNOME Bugzilla – Bug 741274
Performance issue using sqlite >3.8.6
Last modified: 2014-12-12 16:15:35 UTC
Created attachment 292333 [details]
Text copy of pastbin.
I am currently using debian unstable, which uses banshee 2.6.2 and sqlite3 3.8.7.
At some point I started experience performance issues with banshee, and after some searching I landed on an arch bug page here: https://bugs.archlinux.org/task/42500 and also an email exchange which could explain the slowdown, with a possible fix here: http://pastebin.com/GRWpNPTR
After downgrading my sqlite version to stable (3.7.13) the slowdown stopped.
I am also attaching the email exchange to this post as a txt file. It goes on to list a possible query rewrite that may solve the issue, and mentions they may be able to revert the behavior in sqlite 3.8.8. Unfortunately I don't have the knowledge to test such a thing myself.
Thank you for your work.
We're seeing this in Fedora 21+ as well. I looked at the code, and most of the query seems to come from src/Core/Banshee.Services/Banshee.Collection.Database/DatabaseYearListModel.cs ... but not all of it? Someone smarter than me will need to figure out how to make this change.
I think the problem is similar as in bug#740879.
Could you try to apply the patch listed in the bugreport?
If it fixes your problem, perhaps one could also look into the rewritten query.
Thanks for the bug report. This particular bug has already been reported into our bug tracking system, but please feel free to report any further bugs you find.
*** This bug has been marked as a duplicate of bug 740879 ***