[Bug 474514] Re: Banshee very slow when interacting with track lists

[Jim Kirkpatrick]

Right, well lots to reply to...

Yes, I'm using EXT4 - fresh Karmic install. sqlite + ext4 problems could
also explain Liferea's slowness when updating feeds, and Firefox's
occasional oddities.

Chow: 
I'd prefer not to disable file system integrity features, this is my work machine too. I see others (http://bbs.archlinux.org/viewtopic.php?id=65341) are discussing its relative merits... For now though, altering my file system to fix an application is not an acceptable option, sorry.

ajonat:
I'm not on IRC! But yes, I have EXT4... ran your strace and the file is attached as requested.

Gabriel:
Yes, my thoughts exactly: ~1 sec for inserts or even selects(!) implies table scans or duff indexes or just bloated tables - an i7 machine should be able easily handle Banshee's database needs.

# sqlite3 ~/.config/banshee-1/banshee.db ".schema CoreSmartPlaylistEntries" returns:
CREATE TABLE CoreSmartPlaylistEntries (
                    EntryID             INTEGER PRIMARY KEY,
                    SmartPlaylistID     INTEGER NOT NULL,
                    TrackID             INTEGER NOT NULL
                );
CREATE INDEX CoreSmartPlaylistEntriesIndex ON CoreSmartPlaylistEntries(SmartPlaylistID, TrackID);

# sqlite3 ~/.config/banshee-1/banshee.db "analyze" returned almost
immediately, but unfortunately when I ran Banshee the slowness was still
there.

Jim

** Attachment added: "banshee_session.strace"
   http://launchpadlibrarian.net/35853909/banshee_session.strace

-- 
Banshee very slow when interacting with track lists
https://bugs.launchpad.net/bugs/474514
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs at lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs