Re: [sqlite] Performance regression in Banshee with sqlite 3.8.7 on Arch Linux

2014-10-23 Thread Richard Hipp
On Thu, Oct 23, 2014 at 4:03 PM, Tomislav Ljubej wrote: > I've searched Banshee's source code and it seems 'CoreCache' is a TEMP > table according to some comments in the code but I have no clue where > it's actually defined, there is no 'CREATE TABLE' statement in the > code

Re: [sqlite] Performance regression in Banshee with sqlite 3.8.7 on Arch Linux

2014-10-23 Thread Tomislav Ljubej
I've searched Banshee's source code and it seems 'CoreCache' is a TEMP table according to some comments in the code but I have no clue where it's actually defined, there is no 'CREATE TABLE' statement in the code for that particular table (I've searched even with TEMP or TEMPORARY keywords,

Re: [sqlite] Performance regression in Banshee with sqlite 3.8.7 on Arch Linux

2014-10-22 Thread Richard Hipp
Thanks for sending in the performance regression report. On Wed, Oct 22, 2014 at 1:51 PM, Tomislav Ljubej wrote: > Hello, > > There is a performance regression in the media player Banshee on the > query that is in the attachment. The query takes about 13 seconds on > my i7

[sqlite] Performance regression in Banshee with sqlite 3.8.7 on Arch Linux

2014-10-22 Thread Tomislav Ljubej
Hello, There is a performance regression in the media player Banshee on the query that is in the attachment. The query takes about 13 seconds on my i7 4770 processor. I tried the latest stable version before the current one which is 3.8.6.1 and the performance regression doesn't happen, the query