On 2014/09/21 14:12, RSmith wrote:
On 2014/09/20 23:08, Richard Hipp wrote:
On Sat, Sep 20, 2014 at 12:45 PM, Merike <gas...@smail.ee> wrote:
A question: is the query being fast again after analyze call indicative
of the bug being fixed? Because I tried it on my original database too
and there I don't see a speedup after analyze. Should I try to minimize
it to a smaller database again where the bug still occurs, even after
analyze? Or will the change you made fix my original database speed as
well despite the analyze call not helping it?
The change fixes the problem (for us) *without* requiring ANALYZE.
Richard, I think the OP meant to ask whether or not running analyze fixed the bug, maybe a slight misunderstanding and you
probably assumed correct understanding as a benefit of the doubt scenario - so allow me to just add the following in case the OP
did think of it the other way...
On second thought, I think the first interpretation was correct. Merike - just so I understand clearly - you DID download and is
using the new trunk yes? If so, how big is the old DB you tried it on? Could you try the minimize and send the file via a
file-upload service?
It might simply be that Analyze did not get your QP to react on that size DB as it did for us - but if the bug is not fixed it needs
to be seen.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
