Re: [sqlite] DELETE extremely slow (.expert command)

2019-11-02 Thread Keith Medcalf
On Friday, 1 November, 2019 14:52, Thomas Kurz wrote: >That's it!!! You're a genius! Thank you very very much! >Run Time: real 8.290 user 3.25 sys 1.906250 I believe that the SQLite3 CLI has a command .expert that you can use to turn on assistance to tell you if the next executed SQL

Re: [sqlite] DELETE extremely slow (.expert command)

2019-11-02 Thread Thomas Kurz
> It would/should have told you immediately that you needed those two > additional indexes, I should think. Unfortunately not. Someone told me about ".expert" some time ago and it's indeed helpful for me because I never know what indexes to create and why. But for this database everything