Load test of IBP with FB4
Hello Everyone.
I have just gotten the some of results about load test IBP with FB4 those can be analyzed and compared.
In short, the situation is the same as for FB3.
Test with using built-in Firebird client
[20.05.2023 23:36:21] [info] Provider DLL :lcpi.ibprovider-v5_vc17_w64_prof_i.dll [20.05.2023 23:36:21] [info] Provider Version:5.29.0.42372 [20.05.2023 23:36:21] [info] Server Name :Firebird [20.05.2023 23:36:21] [info] Server Version :4.0.3.2937 [20.05.2023 23:36:21] [info] Client Name :LCPI.IBProvider.RemoteFB [20.05.2023 23:36:21] [info] Client Version :5.29.0.42372 [20.05.2023 23:36:21] [info] Database ODS :13.0 [20.05.2023 23:36:21] [info] Database Dialect:3 ... [22.05.2023 01:26:07] [summary] ------------------------------------------- [SUMMARY INFORMATION] [22.05.2023 01:26:07] [summary] [TESTS] [22.05.2023 01:26:07] [summary] EXECUTED : 738000 [22.05.2023 01:26:07] [summary] SUCCEEDED : 737931 [22.05.2023 01:26:07] [summary] FAILED : 12 [ 12 error(s) ] [22.05.2023 01:26:07] [summary] WITH WARNINGS : 57 [ 89 warning(s) ] [22.05.2023 01:26:07] [summary] [22.05.2023 01:26:07] [summary] - - - - - - - - - - - - - - - - - - - - - - [22.05.2023 01:26:07] [summary] [TEST TIMES] [22.05.2023 01:26:07] [summary] REAL : 9261941591927 [10 day(s)17:16:34.1591927] [22.05.2023 01:26:07] [summary] USER : 888992968750 [1 day(s)00:41:39.2968750] [22.05.2023 01:26:07] [summary] KERNEL : 369377500000 [10:15:37.7500000] [22.05.2023 01:26:07] [summary] TOTAL : 1258370468750 [1 day(s)10:57:17.0468750] [22.05.2023 01:26:07] [22.05.2023 01:26:07] [TEST HEAP] Test heap is empty [22.05.2023 01:26:07] [TEST HEAP] Validate ... OK [22.05.2023 01:26:07] [TEST HEAP] Destroy ... OK [22.05.2023 01:26:07] [22.05.2023 01:26:07] [summary] ------------------------------------------- [PROCESS INFORMATION] [22.05.2023 01:26:07] [summary] [VIRTUAL MEMORY] [22.05.2023 01:26:07] [summary] [22.05.2023 01:26:07] [summary] PRIVATE BYTES : 28392 KB [27MB 744KB] [22.05.2023 01:26:07] [summary] PEAK PRIVATE BYTES : 13077864 KB [12GB 483MB 360KB] [22.05.2023 01:26:07] [summary] VIRTUAL SIZE : 4539936 KB [4GB 337MB 544KB] [22.05.2023 01:26:07] [summary] PAGE FAULT COUNT : 117698046 [22.05.2023 01:26:07] [summary] [22.05.2023 01:26:07] [summary] - - - - - - - - - - - - - - - - - - - - - - [22.05.2023 01:26:07] [summary] [HANDLES] [22.05.2023 01:26:07] [summary] [22.05.2023 01:26:07] [summary] HANDLES : 176 [22.05.2023 01:26:07] [summary] [22.05.2023 01:26:07] [summary] - - - - - - - - - - - - - - - - - - - - - - [22.05.2023 01:26:07] [summary] TOTAL ERRORS : 12 [22.05.2023 01:26:07] [summary] TOTAL WARNINGS: 89 [22.05.2023 01:26:07] [summary] FULL PASSES : 1 [22.05.2023 01:26:07] [summary] GEN TESTS : 8332072
Test with using fbclient.dll
[23.05.2023 05:14:21] [info] Provider DLL :lcpi.ibprovider-v5_vc17_w64_prof_i.dll [23.05.2023 05:14:21] [info] Provider Version:5.29.0.42372 [23.05.2023 05:14:21] [info] Server Name :Firebird [23.05.2023 05:14:21] [info] Server Version :4.0.3.2937 [23.05.2023 05:14:21] [info] Client Name :Firebird [23.05.2023 05:14:21] [info] Client Version :4.0.3.2937 [23.05.2023 05:14:21] [info] Database ODS :13.0 [23.05.2023 05:14:21] [info] Database Dialect:3 ... [24.05.2023 07:11:58] [summary] ------------------------------------------- [SUMMARY INFORMATION] [24.05.2023 07:11:58] [summary] [TESTS] [24.05.2023 07:11:58] [summary] EXECUTED : 738012 [24.05.2023 07:11:58] [summary] SUCCEEDED : 737946 [24.05.2023 07:11:58] [summary] FAILED : 17 [ 17 error(s) ] [24.05.2023 07:11:58] [summary] WITH WARNINGS : 50 [ 106 warning(s) ] [24.05.2023 07:11:58] [summary] [24.05.2023 07:11:58] [summary] - - - - - - - - - - - - - - - - - - - - - - [24.05.2023 07:11:58] [summary] [TEST TIMES] [24.05.2023 07:11:58] [summary] REAL : 9308170696534 [10 day(s)18:33:37.0696534] [24.05.2023 07:11:58] [summary] USER : 1063273750000 [1 day(s)05:32:07.3750000] [24.05.2023 07:11:58] [summary] KERNEL : 389622968750 [10:49:22.2968750] [24.05.2023 07:11:58] [summary] TOTAL : 1452896718750 [1 day(s)16:21:29.6718750] [24.05.2023 07:11:58] [24.05.2023 07:11:58] [TEST HEAP] Test heap is empty [24.05.2023 07:11:58] [TEST HEAP] Validate ... OK [24.05.2023 07:11:58] [TEST HEAP] Destroy ... OK [24.05.2023 07:11:58] [24.05.2023 07:11:58] [summary] ------------------------------------------- [PROCESS INFORMATION] [24.05.2023 07:11:58] [summary] [VIRTUAL MEMORY] [24.05.2023 07:11:58] [summary] [24.05.2023 07:11:58] [summary] PRIVATE BYTES : 476108 KB [464MB 972KB] [24.05.2023 07:11:58] [summary] PEAK PRIVATE BYTES : 13164124 KB [12GB 567MB 604KB] [24.05.2023 07:11:58] [summary] VIRTUAL SIZE : 5006404 KB [4GB 793MB 68KB] [24.05.2023 07:11:58] [summary] PAGE FAULT COUNT : 503582383 [24.05.2023 07:11:58] [summary] [24.05.2023 07:11:58] [summary] - - - - - - - - - - - - - - - - - - - - - - [24.05.2023 07:11:58] [summary] [HANDLES] [24.05.2023 07:11:58] [summary] [24.05.2023 07:11:58] [summary] HANDLES : 255 [24.05.2023 07:11:58] [summary] [24.05.2023 07:11:58] [summary] - - - - - - - - - - - - - - - - - - - - - - [24.05.2023 07:11:58] [summary] TOTAL ERRORS : 17 [24.05.2023 07:11:58] [summary] TOTAL WARNINGS: 106 [24.05.2023 07:11:58] [summary] FULL PASSES : 1 [24.05.2023 07:11:58] [summary] GEN TESTS : 8332072
The errors in first case (built-in client) are linked with new unsupported FB4 datatypes. Will be fixed in next IBP releases.
These errors exist in second case plus the old problems of fbclient.dll with statement cancel.
—
In general, the current state is not so bad.