On 20 Mar 2017, at 1:06pm, Richard Hipp <d...@sqlite.org> wrote:

>     https://www.sqlite.org/draft/index.html

In <https://www.sqlite.org/draft/pragma.html#pragma_optimize>

"       • (Not yet implemented) Create indexes that might have been helpful to 
recent queries."

—> 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. "

—> "always"

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 
or not.

sqlite-users mailing list

Reply via email to