On Thu, 14 Apr 2016 09:19:06 -0400 Richard Hipp <drh at sqlite.org> wrote:
> On 4/14/16, John Found <johnfound at asm32.info> wrote: > > > > But after some time working in wild (executing the more complex original > > query), the performance decreased again and despite of existing the index, > > the result of the "explain query plan" is again: > > > > SCAN TABLE T > > USE TEMP B-TREE FOR ORDER BY > > Can you make a copy of the database when it gets into this state, and > send it to us for analysis? Yes, of course. It is around 800KB compressed. Can I attach it to a personal email to you? -- http://fresh.flatassembler.net http://asm32.info John Found <johnfound at asm32.info>
