I was not entirely right.
The above tests were carried out on version 2.5.5, where the result was
obtained in 30 minutes.
After upgrading to version 2.5.8, the test shows the same results
regardless of the processor ~ 1 min.
Also checked for version 3.0, with additional indexes created in
RDB$DEPENDENCIES - everything works similarly fast.
Thus, to solve the issues CORE-5612 and CORE-5746 it is enough to create
the following indexes in RDB$DEPENDENCIES:
not unique - RDB$DEPENDENT_NAME,RDB$DEPENDENT_TYPE
unique
for 2.5 - RDB$DEPENDENT_NAME, RDB$DEPENDED_ON_NAME, RDB$FIELD_NAME,
RDB$DEPENDENT_TYPE, RDB$DEPENDED_ON_TYPE
for 3.0 and above - RDB$DEPENDENT_NAME, RDB$DEPENDED_ON_NAME,
RDB$FIELD_NAME, RDB$DEPENDENT_TYPE, RDB$DEPENDED_ON_TYPE, RDB$PACKAGE_NAME
Should I send pull requests myself in B3_0_Release, and the master branches?
------------------------------------------------------------------------------
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
