ALTER DOMAIN DROP CONSTRAINT and ADD CHECK too slow ---------------------------------------------------
Key: CORE-5453 URL: http://tracker.firebirdsql.org/browse/CORE-5453 Project: Firebird Core Issue Type: Bug Affects Versions: 2.5.6 Reporter: Maxim Kuzmin Priority: Minor Our database has a domain DOM$DATE. It is used in 300 tables and 500 stored procedure. Executing and commit of each of these query's take's about 1 minute: ALTER DOMAIN DOM$DATE DROP CONSTRAINT; ALTER DOMAIN DOM$DATE ADD CHECK (VALUE BETWEEN DATE '01.01.1900' AND DATE '31.12.2100'); P.S. Vlad Khorsun's said it was due to the restructuring of dependencies, but in this case it is not necessary. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel