2021.05.20. 10:36 keltezéssel, Gabor Boros írta:
Hi All,
I try to find why the real life application's internal database version
changer much slower with 4.0. One slow step is the procedure altering.
Vlad suggested and index privately: RDB$DEPENDENCIES
(RDB$DEPENDENT_NAME, RDB$DEPENDED_ON_NAME, RDB$FIELD_NAME). Thank you Vlad!
Two charts attached, which based on real life numbers.
- 20210518.png - 2.5.9 vs. 3.0.7 vs. 4.0 (actual snapshot at 2021.05.18)
- 20210709.png - 2.5.9 vs. 3.0.7 vs. 4.0 (actual snapshot at 2021.07.09)
+ added the above index to all versions.
X axis is the steps of the database version changer, Y is the elapsed
time in seconds.
Gabor
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
