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

Reply via email to