On Mon, 6 Mar 2017 18:52:48 -0500 Richard Hipp <d...@sqlite.org> wrote:
> On 3/6/17, Simon Slavin <slav...@bigfraud.org> 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 > d...@sqlite.org --- --- Eduardo Morras <emorr...@yahoo.es> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
