Comment 11 for bug 474514

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