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 [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs -- universe-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/universe-bugs
