On 20 Mar 2017, at 1:06pm, Richard Hipp <d...@sqlite.org> wrote:
" • (Not yet implemented) Create indexes that might have been helpful to
—> If I recall a previous conversation correctly, it might clarify things to
make this sentence end "queries executed by this connection.". On the other
hand you may have changed your idea about how this should work and that may no
longer be accurate.
"The default MASK is and alway shall be 0xfffe. "
If it’s possible to specify masks using BLOB-type hex values, could you provide
an example which shows how ? Simply saying that "PRAGMA optimize(0x2);" works
would be good enough.
"In the current implementation, a table is analyzed if only if"
—> "analyzed only if"
" • Debugging mode. Do not actually perform any optimizations but instead
return one line of text for each optimization that would have been done."
—> The section describes what is returned in debugging mode, but not what is
returned in normal mode. Presumably it returns that same text.
I see two patterns of use for this. Some programmers will just use normal
mode. Others will use debugging mode first, and count the number of lines
returned. If the count is non-zero they will put up a dialog telling the user
of a possible delay, allowing them to pick whether the optimizations are done
sqlite-users mailing list