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 565730 - Banshee is really jittery and its cpu reaches 100% too often
Banshee is really jittery and its cpu reaches 100% too often
Status: RESOLVED INCOMPLETE
Product: banshee
Classification: Other
Component: general
1.4.1
Other Linux
: Normal major
: 1.x
Assigned To: Banshee Maintainers
Banshee Maintainers
Depends on:
Blocks:
 
 
Reported: 2008-12-26 21:49 UTC by Amr Hassan
Modified: 2009-10-04 21:35 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Amr Hassan 2008-12-26 21:49:14 UTC 
Hi,

I'm using banshee to manage a my music collection that has over 14K track files and I'm having a very serious performance issues doing very simple tasks like skipping through my library on shuffle, or filtering it for a specific artist or album. I often get 100% cpu usage spikes and banshee stops responding in the middle for a second or so.

I'm running Banshee 1.4.1 on Ubuntu 8.10 and sqlite3 version 3.5.9. My machine has a 3.0GHz P4 processor with HT, 1GB of ram and 2 GB of swap memory.

I've attached a sql-log and I've uploaded my compressed database to http://dl.getdropbox.com/u/197580/banshee.db.tar.bz2

And here's my sql-log: http://dl.getdropbox.com/u/197580/banshee-sql-log.tar.bz2

Original mailing list thread: http://www.nabble.com/Can-i-use-MySql-for-a-database--td21176384.html
Comment 1 Bertrand Lorentz 2008-12-28 17:36:09 UTC 
So I played around a bit with your DB :
First I set all uris to point to one of my mp3 file (update coretracks set uri = 'file:///home/lorentz/test.mp3'). Then I started banshee with this DB and skipped through a few tracks on shuffle.

The execution times I get for the same queries is about 3 or 4 times lower (314ms compared to 1113ms for example).

The software versions are the same, and my processor is a Core2 Duo 2.5GHz, with 1GB of RAM. So I think there might be some other factor involved in your performance issues.
Comment 2 Gabriel Burt 2009-06-05 23:16:25 UTC 
Any better against 1.5.0?
Comment 3 Bertrand Lorentz 2009-10-04 21:35:33 UTC 
Closing this bug report as no further information has been provided. Please feel free to reopen this bug if you can provide the information asked for.
Thanks!