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.
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.