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

2014-10-23 Thread Tomislav Ljubej
.html Anyway I have attached the .fullschema output. On Thu, Oct 23, 2014 at 3:09 AM, Richard Hipp <d...@sqlite.org> wrote: > Thanks for sending in the performance regression report. > > On Wed, Oct 22, 2014 at 1:51 PM, Tomislav Ljubej <spor...@gmail.com&

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

2014-10-22 Thread Tomislav Ljubej
sure it's actually referring to 'CoreCacheModels', I got the query from Banshee's debug output so it may not reflect the actual names in the database. -- Tomislav Ljubej DELETE FROM CoreCache WHERE ModelID = 9; INSERT INTO CoreCache (ModelID, ItemID) SELECT 9