[Bug 688781] Re: Fix performance regression affecting Banshee
** Branch linked: lp:ubuntu/maverick-updates/sqlite3 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee To manage notifications about this bug go to: https://bugs.launchpad.net/banshee/+bug/688781/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
** Changed in: banshee Status: Fix Released => Unknown -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
** Changed in: banshee Status: Incomplete => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
** Changed in: banshee Status: Unknown => Incomplete ** Changed in: banshee Importance: Unknown => Medium -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
** Also affects: sqlite Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
This bug was fixed in the package sqlite3 - 3.7.2-1ubuntu0.1 --- sqlite3 (3.7.2-1ubuntu0.1) maverick-proposed; urgency=low * debian/patches/21-688781-where-performance-regression.patch: Backport a fix for a performance regression relating to SQL queries using the WHERE conditional (lp: #688781). Patch adapted from upstream commit: ece641eb89 -- Sameer MorarMon, 13 Dec 2010 18:01:14 +0200 ** Changed in: sqlite3 (Ubuntu Maverick) Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
Hi gsiliceo Could you rather use the package that has been uploaded to the maverick- proposed (https://wiki.ubuntu.com/Testing/EnableProposed) repository. Additional verification will help get the fixed package into maverick- updates sooner. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
I was affected too and i solved it with Sameer Morar's PPA 1) exit banshee 2) add the PPA: ppa:smorar/random 3) update your system Step 2 and 3 can be easily performed in a gnome-terminal thusly: sudo apt-add-repository ppa:smorar/random sudo apt-get update && sudo apt-get upgrade -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
Thank you on behalf of the Banshee team, our Maverick testers for the Natty switch to Banshee will be able to produce far more useful feedback to us now. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
I've following the test case and the results are: with the current sqlite on Maverick: real0m4.811s user0m4.748s sys 0m0.012s with the proposed version: real0m0.113s user0m0.104s sys 0m0.004s Tested Banshee as well and you can feel that the performance is improved specially when analyzing the whole library. Marking this as verification done, thanks all. ** Tags added: verification-done ** Tags removed: verification-needed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
Fair enough. Re-tagging that verification is needed. ** Tags added: verification-needed ** Tags removed: verification-done -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
I would think due to the nature of this fix, someone else should verify. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
The proposed package works for me My results using the testcase are as follows: sqlite3 3.7.2-1 from maverick: real0m8.468s user0m8.193s sys 0m0.016s sqlite3 3.7.2.1ubuntu0.1 from maverick-proposed: real0m0.463s user0m0.184s sys 0m0.012s ** Tags added: verification-done ** Tags removed: verification-needed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
Accepted sqlite3 into maverick-proposed, the package will build now and be available in a few hours. Please test and give feedback here. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation how to enable and use -proposed. Thank you in advance! ** Tags added: verification-needed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
sorry Sameer for not commenting but I've fixed and reuploaded the update already -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
** Patch added: "Patch with fixed bug reference in the changelog" https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/688781/+attachment/1766717/+files/sqlite3_3.7.2-1ubuntu0.1.debdiff -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
The diff looks fine, but please reupload with a fixed bug reference in the changelog. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
Thank you for your work, I've sponsored the debdiff now -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
the issue is fixed in natty ** Changed in: sqlite3 (Ubuntu) Importance: Undecided => Low ** Changed in: sqlite3 (Ubuntu) Status: Confirmed => Fix Released ** Also affects: sqlite3 (Ubuntu Maverick) Importance: Undecided Status: New ** Changed in: sqlite3 (Ubuntu Maverick) Importance: Undecided => Low ** Changed in: sqlite3 (Ubuntu Maverick) Status: New => Fix Committed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
** Bug watch added: GNOME Bug Tracker #631180 https://bugzilla.gnome.org/show_bug.cgi?id=631180 ** Also affects: banshee via https://bugzilla.gnome.org/show_bug.cgi?id=631180 Importance: Unknown Status: Unknown -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
** Tags added: sru ** Tags removed: upgrade ** Tags removed: wishlist -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
TEST CASE: 1) Download attachments: banshee.db and banshee-test.sql 2) Run the following command: time sqlite3 banshee.db < banshee-test.sql My results using sqlite3 3.7.2-1 from maverick: real0m8.317s user0m1.840s sys 0m0.004s My results using sqlite3 3.7.2-1ubuntu0.1 from ppa:smorar/bugfixes, patched with the attached patch: real0m0.202s user0m0.176s sys 0m0.012s Note the improvement in execution time -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
** Attachment added: "SQL commands that demonstrate the bug" https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/688781/+attachment/1766210/+files/banshee-test.sql -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
** Attachment added: "Banshee database for testcase" https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/688781/+attachment/1766209/+files/banshee.db -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
** Tags added: patch -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 688781] Re: Fix performance regression affecting Banshee
** Summary changed: - Please update to 3.7.3 or 3.7.4 in Maverick + Fix performance regression affecting Banshee -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/688781 Title: Fix performance regression affecting Banshee -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs