** 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
** 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
** 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
** 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
** 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
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
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
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
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
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.
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)
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
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
--
** 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
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
--
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
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:
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
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
** 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.
** 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.
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
** 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
** 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
** 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
** 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
26 matches
Mail list logo