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 625423 - ~19000ms SELECT INNER JOIN WHERE in SqliteModelCache.cs
~19000ms SELECT INNER JOIN WHERE in SqliteModelCache.cs
Status: RESOLVED DUPLICATE of bug 625783
Product: banshee
Classification: Other
Component: general
1.6.1
Other Linux
: Normal major
: 1.x
Assigned To: Banshee Maintainers
Banshee Maintainers
Depends on:
Blocks:
 
 
Reported: 2010-07-27 18:53 UTC by only.halfdream
Modified: 2010-08-02 13:44 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description only.halfdream 2010-07-27 18:53:49 UTC 
So after i updated to sqlite 3.7 (im on archlinux), i launch banshee and then appear a huge lag that eats all my CPU. The database has been vacuumed and analyzed but without any improvements. Here is the log of banshee :
http://pastebin.com/Vsu1Znsf
I also got a complete saving of confs file and database.
Comment 1 only.halfdream 2010-07-27 18:57:23 UTC 
here you are for the bugs and database :
http://omploader.org/vNTJhMg
Comment 2 Tim Fuchs 2010-07-29 13:21:59 UTC 
I can confirm this bug on Ubuntu Maverick.

The culprit is definitely sqlite 3.7, I downgraded to 3.6.* as a workaround

Not only is Banshee incredibly slow with 3.7, the sorting is also completeley messed up.

If I can provide more information please let me know.
Comment 3 only.halfdream 2010-07-29 13:29:49 UTC 
Yeah you're right when banshee finally starts the songs are "organized" in a completely weird way.
Comment 4 David Nielsen 2010-07-30 14:55:36 UTC 
This query especially seems to dislike the new SQLite for me, I hit +500.000ms each time it is run 

(taken from the bug report log)
[2 Debug 20:11:57.546] Executed in 18327ms
                    DELETE FROM CoreCache WHERE ModelID = 1;
                        INSERT INTO CoreCache (ModelID, ItemID) SELECT 1, CoreArtists.ArtistID
                FROM CoreArtists WHERE CoreArtists.ArtistID IN
                    (SELECT CoreTracks.ArtistID FROM CoreTracks, CoreCache
                        WHERE CoreCache.ModelID = 39 AND
                              CoreCache.ItemID = CoreTracks.TrackID )
                    ORDER BY NameSortKey

Since it seems clear that the SQLite upgrade is the catalyst it seems prudent to examine the changelog.

http://www.sqlite.org/changes.html

Nothing stands out to me though.
Comment 5 Iain Lane 2010-08-02 12:31:12 UTC 
Thanks for the bug report. This particular bug has also been filed as bug #625783, which has more information attached to it. I'm therefore marking this bug as a duplicate of the other. Please feel free to report any other bugs you find.

*** This bug has been marked as a duplicate of bug 625783 ***
Comment 6 only.halfdream 2010-08-02 13:44:38 UTC 
No problem since the person appears to be ubuntu i can run tests on archlinux as well.