Em 13/10/2016 20:19, Slavomir Skopalik escreveu: > Hi, > > I was tested FB3.0.1 Windows 64 with different result. > > DaviceData is table with several millions of rows. > > alter table DeviceData add a integer default 7 not null; > > This is fast, just few ms. > > But commit was taken several minutes with high disk activities.
Probably just reads validating the table. We probably can add some heuristic to not validate in this case. Adriano ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel