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.
First, made an isql test case with WIN1250 connection because the real
life application use that. The script file alter 2265 procedures in the
database. Just restored an fbk and execute the script with isql. Tried
with Win64 and SuperServer.
isql.exe -u SYSDBA -p masterkey -ch WIN1250
localhost:C:\TEST\DB\TEST.FDB -i C:\TEST\TEST_ansi.sql
2.5.9 - ~43s
3.0.7 - ~111s
4.0.0.2489 - ~124s
Tried with UTF8 too because system tables of 3.0 and 4.0 use that
encoding. Saved and use the script file with UTF8 encoding.
isql.exe -u SYSDBA -p masterkey -ch UTF8 localhost:C:\TEST\DB\TEST.FDB
-i C:\TEST\TEST_utf8.sql
2.5.9 - ~42s
3.0.7 - ~88s
4.0.0.2489 - ~96s
Any idea why the execution much slower with the newer versions than 2.5?
Gabor
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
