I've following the test case and the results are: with the current sqlite on Maverick:
real 0m4.811s user 0m4.748s sys 0m0.012s with the proposed version: real 0m0.113s user 0m0.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