After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 741274 - Performance issue using sqlite >3.8.6
Performance issue using sqlite >3.8.6
Status: RESOLVED DUPLICATE of bug 740879
Product: banshee
Classification: Other
Component: general
2.6.2
Other Linux
: Normal major
: ---
Assigned To: Banshee Maintainers
Banshee Maintainers
Depends on:
Blocks:
 
 
Reported: 2014-12-08 21:24 UTC by Charles
Modified: 2014-12-12 16:15 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
Text copy of pastbin. (2.67 KB, text/plain)
2014-12-08 21:24 UTC, Charles 		Details

Description Charles 2014-12-08 21:24:48 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.
Comment 1 Tom 'spot' Callaway 2014-12-09 19:15:41 UTC 
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.
Comment 2 Samuel Gyger (IRC: thinkabout) 2014-12-10 10:25:09 UTC 
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.
Comment 3 Andrés G. Aragoneses (IRC: knocte) 2014-12-12 16:15:35 UTC 
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 ***