Re: [sqlite] dramatic performance drop somewhere between 3.7.09.0 and 3.7.17.0

2013-05-27 Thread Richard Hipp
On Mon, May 27, 2013 at 2:36 PM, Wolfgang Enzinger wrote: > Hallo list, > > I detected a dramatic performance drop with a certain query which occurred > somewhere between versions 3.7.09.0 and 3.7.17.0. Now this is not a real > showstopper because I also noticed than an ANALYZE cures the issue in

Re: [sqlite] dramatic performance drop somewhere between 3.7.09.0 and 3.7.17.0

2013-05-27 Thread Wolfgang Enzinger
Richard Hipp writes: > However, once we get the new query planner running and ready to beta-test, > we really, really would appreciate you giving it a spin and letting us know > if you encounter any problems with it. Alright, will do. Thanks for the great work! Wolfgang __

[sqlite] dramatic performance drop somewhere between 3.7.09.0 and 3.7.17.0

2013-05-27 Thread Wolfgang Enzinger
Hallo list, I detected a dramatic performance drop with a certain query which occurred somewhere between versions 3.7.09.0 and 3.7.17.0. Now this is not a real showstopper because I also noticed than an ANALYZE cures the issue in the latter version immediately. However, the drop without ANALYZE is