On Mon, 6 Mar 2017 18:52:48 -0500 Richard Hipp <[email protected]> wrote:
> On 3/6/17, Simon Slavin <[email protected]> wrote: > > > >> See > >> https://www.sqlite.org/draft/pragma.html#pragma_optimize for > >> additional information. > > > > I?m sure this is extremely far-future-looking, but a default mask > > of 254 (0xfe) might be better than the stated default of 14 (0x0e). > > Default mask changed to 0xfffe, which allows for up to 14 new > default-on optimizations and up to 48 new default-off optimizations. Could a trigger be fired on optimize? This way we could add database/schema specific optimizations (Delete all rows in table tab where column value is NULL, for example) Thanks for the great work. > -- > D. Richard Hipp > [email protected] --- --- Eduardo Morras <[email protected]> _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
