IBProvider v5.34
A new version of IBProvider was completely tested and released.
While this version was developing I found and fixed one really old problem of loading an array description from database. Provider used an incorrect query that might (only theoretical) return a wrong result and (that is important) had a wrong PLAN.
A correction of second thing reduced an execution time of all the load tests (FB4, d1/d3, 32/64 bits, direct/fbclient, debug/release) to one week instead two ones.
Here are old and new results of the one combination.
Old IBProvider v3.33 (x64)
[22.10.2023 22:48:40] [info] Provider DLL :lcpi.ibprovider-v5_vc17_w64_prof_i.dll [22.10.2023 22:48:40] [info] Provider Version:5.33.0.45641 [22.10.2023 22:48:40] [info] Server Name :Firebird [22.10.2023 22:48:40] [info] Server Version :4.0.4.3002 [22.10.2023 22:48:40] [info] Client Name :LCPI.IBProvider.RemoteFB [22.10.2023 22:48:40] [info] Client Version :5.33.0.45641 [22.10.2023 22:48:40] [info] Database ODS :13.0 [22.10.2023 22:48:40] [info] Database Dialect:3 ... [24.10.2023 02:37:48] [summary] ------------------------------------------- [SUMMARY INFORMATION] [24.10.2023 02:37:48] [summary] [TESTS] [24.10.2023 02:37:48] [summary] EXECUTED : 746770 [24.10.2023 02:37:48] [summary] SUCCEEDED : 746712 [24.10.2023 02:37:48] [summary] FAILED : 0 [24.10.2023 02:37:48] [summary] WITH WARNINGS : 58 [ 79 warning(s) ] [24.10.2023 02:37:48] [summary] [24.10.2023 02:37:48] [summary] - - - - - - - - - - - - - - - - - - - - - - [24.10.2023 02:37:48] [summary] [TEST TIMES] [24.10.2023 02:37:48] [summary] REAL : 9979236316708 [11 day(s)13:12:03.6316708] [24.10.2023 02:37:48] [summary] USER : 962695781250 [1 day(s)02:44:29.5781250] [24.10.2023 02:37:48] [summary] KERNEL : 395262187500 [10:58:46.2187500] [24.10.2023 02:37:48] [summary] TOTAL : 1357957968750 [1 day(s)13:43:15.7968750] [24.10.2023 02:37:48] [24.10.2023 02:37:48] [TEST HEAP] Test heap is empty [24.10.2023 02:37:48] [TEST HEAP] Validate ... OK [24.10.2023 02:37:48] [TEST HEAP] Destroy ... OK [24.10.2023 02:37:48] [24.10.2023 02:37:48] [summary] ------------------------------------------- [PROCESS INFORMATION] [24.10.2023 02:37:48] [summary] [VIRTUAL MEMORY] [24.10.2023 02:37:48] [summary] [24.10.2023 02:37:48] [summary] PRIVATE BYTES : 25388 KB [24MB 812KB] [24.10.2023 02:37:48] [summary] PEAK PRIVATE BYTES : 13065068 KB [12GB 470MB 876KB] [24.10.2023 02:37:48] [summary] VIRTUAL SIZE : 4492508 KB [4GB 291MB 220KB] [24.10.2023 02:37:48] [summary] PAGE FAULT COUNT : 119397153 [24.10.2023 02:37:48] [summary] [24.10.2023 02:37:48] [summary] - - - - - - - - - - - - - - - - - - - - - - [24.10.2023 02:37:48] [summary] [HANDLES] [24.10.2023 02:37:48] [summary] [24.10.2023 02:37:48] [summary] HANDLES : 173 [24.10.2023 02:37:48] [summary] [24.10.2023 02:37:48] [summary] - - - - - - - - - - - - - - - - - - - - - - [24.10.2023 02:37:48] [summary] TOTAL ERRORS : 0 [24.10.2023 02:37:48] [summary] TOTAL WARNINGS: 79 [24.10.2023 02:37:48] [summary] FULL PASSES : 1 [24.10.2023 02:37:48] [summary] GEN TESTS : 8340892
New IBProvider v3.34 64bit
[08.12.2023 02:44:54] [info] Provider DLL :lcpi.ibprovider-v5_vc17_w64_prof_i.dll [08.12.2023 02:44:54] [info] Provider Version:5.34.0.46640 [08.12.2023 02:44:54] [info] Server Name :Firebird [08.12.2023 02:44:54] [info] Server Version :4.0.5.3033 [08.12.2023 02:44:54] [info] Client Name :LCPI.IBProvider.RemoteFB [08.12.2023 02:44:54] [info] Client Version :5.34.0.46640 [08.12.2023 02:44:54] [info] Database ODS :13.0 [08.12.2023 02:44:54] [info] Database Dialect:3 ... [08.12.2023 15:17:08] [summary] ------------------------------------------- [SUMMARY INFORMATION] [08.12.2023 15:17:08] [summary] [TESTS] [08.12.2023 15:17:08] [summary] EXECUTED : 751898 [08.12.2023 15:17:08] [summary] SUCCEEDED : 751844 [08.12.2023 15:17:08] [summary] FAILED : 0 [08.12.2023 15:17:08] [summary] WITH WARNINGS : 54 [ 73 warning(s) ] [08.12.2023 15:17:08] [summary] [08.12.2023 15:17:08] [summary] - - - - - - - - - - - - - - - - - - - - - - [08.12.2023 15:17:08] [summary] [TEST TIMES] [08.12.2023 15:17:08] [summary] REAL : 4273219237213 [4 day(s)22:42:01.9237213] [08.12.2023 15:17:08] [summary] USER : 1171577343750 [1 day(s)08:32:37.7343750] [08.12.2023 15:17:08] [summary] KERNEL : 444367031250 [12:20:36.7031250] [08.12.2023 15:17:08] [summary] TOTAL : 1615944375000 [1 day(s)20:53:14.4375000] [08.12.2023 15:17:08] [08.12.2023 15:17:08] [TEST HEAP] Test heap is empty [08.12.2023 15:17:08] [TEST HEAP] Validate ... OK [08.12.2023 15:17:08] [TEST HEAP] Destroy ... OK [08.12.2023 15:17:08] [08.12.2023 15:17:08] [summary] ------------------------------------------- [PROCESS INFORMATION] [08.12.2023 15:17:08] [summary] [VIRTUAL MEMORY] [08.12.2023 15:17:08] [summary] [08.12.2023 15:17:08] [summary] PRIVATE BYTES : 29632 KB [28MB 960KB] [08.12.2023 15:17:08] [summary] PEAK PRIVATE BYTES : 13083728 KB [12GB 489MB 80KB] [08.12.2023 15:17:08] [summary] VIRTUAL SIZE : 4557348 KB [4GB 354MB 548KB] [08.12.2023 15:17:08] [summary] PAGE FAULT COUNT : 124257081 [08.12.2023 15:17:08] [summary] [08.12.2023 15:17:08] [summary] - - - - - - - - - - - - - - - - - - - - - - [08.12.2023 15:17:08] [summary] [HANDLES] [08.12.2023 15:17:08] [summary] [08.12.2023 15:17:08] [summary] HANDLES : 174 [08.12.2023 15:17:08] [summary] [08.12.2023 15:17:08] [summary] - - - - - - - - - - - - - - - - - - - - - - [08.12.2023 15:17:08] [summary] TOTAL ERRORS : 0 [08.12.2023 15:17:08] [summary] TOTAL WARNINGS: 73 [08.12.2023 15:17:08] [summary] FULL PASSES : 1 [08.12.2023 15:17:08] [summary] GEN TESTS : 8341521
It looks, for me, really fine.